Date sorting problem

[sophie63]

I have an issue with my x-axis which is not sorted in chronological order. I created a column to ahh index from 1 (jan 2016) to 15 (Mar 2017) but even the index are not well sorted.

 How can I solve this issue?

[sophie63]

Hi,

I have an issue with my x-axis which is not sorted in chronological order. I created a column to ahh index from 1 (jan 2016) to 15 (Mar 2017) but even the index are not well sorted.

 How can I solve this issue?

[Vvelarde · Accepted solution]

@sophie63

hi, your index is type number or text?. Should be number.

[sophie63]

@Vvelarde indeed it was Text instead of number I  figured that out after posting ! I changed the type and the problem is solved. Thanks! 🙂