Why Axis Type Is Missing in an Excel Bar Chart
Question details
The user wants to understand why the Axis Type setting is missing from an Excel bar chart and how to work with dates on the axis.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Formatting an axis in a bar chart that uses dates or category labels.
- Observed behavior
- The horizontal axis is a numeric value axis and does not show the category Axis Type setting.
Check which axis you selected: in a standard Excel bar chart, categories are vertical and values are horizontal. If you need a date axis, verify that the source cells contain real Excel dates rather than text that only looks like dates.
Check the category axis and its date settings
Use this approach when dates should appear as category labels on the vertical axis of a bar chart.
Click the vertical axis labels in the bar chart, right-click, and choose Format Axis.
In the Format Axis pane, open Axis Options and look for Axis Type. If Date axis is available and the categories contain real dates, select it.
If the dates are not being recognized, inspect the source cells and convert date-like text to real dates. Use Chart Design > Select Data to confirm that the category labels refer to those cells.

Use an XY scatter chart for a horizontal date axis
Use a scatter chart when horizontal positions must represent actual dates and intervals rather than bar-chart categories.
Create and edit spreadsheet charts with WPS Office
WPS Office is a free, lightweight alternative for working with spreadsheets and charts in a familiar interface. Open compatible Excel files to continue your work without a complicated migration; WPS does not change Excel's axis settings.

Frequently Asked Questions
Why is Axis Type missing from the horizontal axis?
In a standard bar chart, the horizontal axis is a numeric value axis, not a category axis. Right-click the vertical category labels and choose Format Axis to check the available category-axis options.
Why does Excel treat my dates as text?
The source cells may contain date-like text rather than Excel date values. Check the cells and convert the text to real dates, then use Chart Design > Select Data to verify the category label range.
Can I show dates on the horizontal axis of a bar chart?
Yes. A bar chart's horizontal axis can display numeric Excel date values formatted as dates, such as in a stacked-bar Gantt chart. Right-click the axis, choose Format Axis, and select a date format under Number.
When should I use a scatter chart instead of a bar chart?
Use Insert > Scatter (X, Y) when the horizontal position must reflect actual numeric date intervals. A scatter chart plots values as points or lines rather than category bars.




