Forum Discussion
Axis Options does not include Axis Type
I have a bar chart that I'd like to change to show every 3 months on the x-axis, apparently a common question on the internet, but nothing shows me what to do if 'Axis Type' doesn't even exist under ...
Your chart is a bar chart, so the vertical axis is the category axis (aka x-axis) and the horizontal axis is the value axis (aka y-axis).
The value axis does not have an axis type property - it is always numeric.
And in your example, the categories are text values, so the category axis is a text axis.
So how do you recommend I go about formatting the dates for the bar chart?
Scroll down the Format Axis task pane (shown in your screenshot).
Expand Number at the bottom:
Either select the desired format from the Type drop down, or enter a custom format in the Format Code box and click Add.