Chart Axis inserting values that do not exist in data

Question

I have fiscal year month data that when added to a stacked bar chart is included data that does not exist.

Values are

201401 50 units

201402 60 units

...

201412 xx unit

201501 xx units

...

I do not have show items with no data checked but for some reason it is inserting values.

Is there a way to ensure that only the values found are used for the Axis?

Thanks.

greg_deckler · Answer

Try changing your x-axis to categorical instead of linar and see if that solves it.

douglasaplummer · Answer

That did the trick, thanks much

Forum Discussion