Forum Discussion

Mizunashi's avatar
Mizunashi
Regular Visitor
9 years ago
Solved

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

     

1 Reply

  • Hi Mizunashi,

     

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

     

    Regards,

     

    MFelix