Chart & Visualization Issues

Why Axis Type Is Missing in an Excel Bar Chart

Bushra ParveenBushra Parveen Nov 18, 2026 869 views

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.

Why Axis Type Is Missing in an Excel Bar Chart
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the category axis

Click the vertical axis labels in the bar chart, right-click, and choose Format Axis.

2
Review axis options

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.

3
Check the source labels

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.

Check the category axis and its date settings
Horizontal bar-chart axis: The horizontal axis is a value axis, so it does not have the category Axis Type setting. A date axis may also be unavailable for some chart types or configurations.
Free Microsoft Office alternative

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.

Create and edit spreadsheet charts, including bar and scatter chartsOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for an easier transitionWork with a free, lightweight office suite
microsoft office alternative - wps office

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.