Show Excel Chart Axis Labels at the Top and Bottom
Question details
Show the same horizontal category-axis labels at both the top and bottom of an Excel chart.

- 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.
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.
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.
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.
In the Select Data Source dialog, click Add. Paste the copied reference into Series Values, then click OK and close the dialog.
Select the duplicate series in the chart. On the Format tab, click Format Selection, then under Series Options select Secondary Axis.
Select the chart and choose Chart Design > Add Chart Element > Axes > Secondary Horizontal. The new horizontal axis normally appears at the top.
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.
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.

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.

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.




