0 in x axis

[Mizunashi]

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~

[MFelix · Accepted solution]

Hi @Mizunashi,

You need to change the type of x-axis from continuous to categorical (see image).

Regards,

MFelix