Chart & Visualization Issues

Show Excel Chart Axis Labels at the Top and Bottom

Chanuka GeekiyanageChanuka Geekiyanage Nov 18, 2026 869 views

Question details

Show the same horizontal category-axis labels at both the top and bottom of an Excel chart.

Show Excel Chart Axis Labels at the Top and Bottom
Product
Microsoft Excel
Device & OS
not provided
Scenario
A chart needs category labels in two locations so readers can see them above and below the plot.
Observed behavior
Excel normally places a horizontal axis's labels at either the top or the bottom, rather than both.
Before you start

Select the chart and identify an existing data series and the cell range containing its category labels. The secondary-axis options become available after a series is assigned to a secondary axis.

Solution 1Recommended

Add a duplicate series and a secondary horizontal axis

Use a secondary horizontal axis to display a second set of category labels above the chart.

1
Copy the series values

Select the chart, then choose Chart Design > Select Data. Under Legend Entries (Series), select an existing series, click Edit, and copy the Series Values reference. Click OK.

2
Add a duplicate series

In the Select Data Source dialog, click Add. Paste the copied reference into Series Values, then click OK and close the dialog.

3
Move the duplicate to a secondary axis

Select the duplicate series in the chart. On the Format tab, click Format Selection, then under Series Options select Secondary Axis.

4
Show the second horizontal axis

Select the chart and choose Chart Design > Add Chart Element > Axes > Secondary Horizontal. The new horizontal axis normally appears at the top.

5
Check the category labels

Choose Chart Design > Select Data and check the Horizontal (Category) Axis Labels for the original and duplicate series. If needed, select the duplicate series, click Edit under the axis labels, and select the same label range used by the original.

6
Adjust the axes

Right-click each horizontal axis and choose Format Axis. Under Labels, set Label Position to Low for the bottom axis and High for the top axis if necessary. To hide the secondary vertical axis, select it and use Format Axis to hide its labels, tick marks, and line.

Add a duplicate series and a secondary horizontal axis
Check the chart appearance: The duplicate series may change the chart's appearance or add a legend entry. Format the duplicate as needed and check the secondary vertical-axis scale before hiding that axis.
Free Microsoft Office alternative

Create and edit spreadsheet charts with WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open Excel workbooks and continue editing your data and charts in WPS Spreadsheets; it does not change axis settings in Microsoft Excel.

Create and edit charts from spreadsheet dataCompatible with Microsoft Excel formats such as XLSX and XLSFamiliar spreadsheet interface for an easier transitionFree and lightweight for everyday office tasks
microsoft office alternative - wps office

Frequently Asked Questions

Why is Secondary Horizontal unavailable in Excel?

First assign a series to the secondary axis. Select the series, choose Format > Format Selection, and select Secondary Axis under Series Options. Then check Chart Design > Add Chart Element > Axes.

How do I make the top and bottom labels match?

Open Chart Design > Select Data and check the Horizontal (Category) Axis Labels for each series. If needed, click Edit for the duplicate series and select the same label range as the original.

Can I hide the secondary vertical axis?

Yes. Right-click the secondary vertical axis and choose Format Axis, then hide its labels, tick marks, and line. Keeping the axis hidden rather than deleting it preserves the secondary-axis setup.

Why did adding the duplicate series change my chart?

The duplicate is plotted as another data series and may use a different vertical-axis scale. Select it and use Format > Format Selection to adjust its appearance, and check the secondary axis scale.