Forum Discussion
Mizunashi
9 years agoRegular Visitor
0 in x axis
Hi,
I have a set of data with separated months column.
The months are obviously ranged from 1 to 12
However, when I used it as a line and stacked column chart,
There is always a 0 in front of everything with no values at all.
Filtered using Months greater than 0 or greater than or equal to 1... Using the top 12 values... nothing seems to work and it always shows the 0.
Everyone is pursuing me for the 0 in the beginning.. Used edit query to filter the numbers, but there is no 0 at all in the query editor filter.
Can anyone help?
Thank you~
Hi Mizunashi,
You need to change the type of x-axis from continuous to categorical (see image).
Regards,
MFelix