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 'Axis Options.' For reference, I followed instructions here: https://support.microsoft.com/en-us/topic/display-or-change-dates-on-a-category-axis-d5a8146b-d457-43d1-8602-c1d23c96d650
The 'Start Date' column is formatted as date and I've selected 'Format Axis' to show the missing 'Axis Type' under 'Axis Options.' Any recommendations on how to get that option so I can easily show 1/1/23, 3/1/23, 6/1/23, 10/1/23, etc.?
(I'm building a Gantt chart, example of step one shown in image)
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.
