Stacked Column showing too many columns

[Mr_Fong]

I have a column chart with 125 fields, however it is showing 140 fields (15 blank) on the chart.  I have tried filtering to "<126" but that does not work:

125 data points

15 blank fields

How can I display the chart with only 125?

[MFelix · Accepted solution]

Hi @Mr_Fong ,

On the X-axis options, change the Type from continuous to Categorical this will only show the 125 values, another option is to set the end value of the X-axis to 125 (not the best one).

Regards,

MFelix

[Mr_Fong]

@MFelix 

Changing the X to Categorical did some other weirdness, but limiting the X to 125 worked perfectly! 

Thanks!