Fix Excel Chart Horizontal Axis Labels Changing When Using a Secondary Axis
Question details
Horizontal category labels on an Excel chart change unexpectedly when a data series is moved to a secondary axis.
- Product
- Microsoft Excel 2016
- Device & OS
- not provided
- Scenario
- Adding a secondary axis to an existing chart to compare two different data series with contrasting values or scales.
- Observed behavior
- The category labels on the horizontal axis change, misalign, or revert to default numbers (1, 2, 3) immediately after applying the secondary axis to a series.
Ensure that the data ranges for both your primary and secondary series share the exact same category labels in your source worksheet to prevent accidental misalignment.
Manually Reassign Secondary Axis Labels
Use this method to explicitly define the correct horizontal axis labels for the series plotted on the secondary axis.
When you move a series to a secondary axis, Excel sometimes generates a hidden secondary horizontal axis with default labels. Manually editing the data source for this specific series forces Excel to use your intended categories.
Right-click anywhere on the chart area and select 'Select Data' from the context menu to open the Select Data Source dialog box.
In the left pane (Legend Entries), click on the name of the data series that you recently moved to the secondary axis.
Click the 'Edit' button located in the right pane under 'Horizontal (Category) Axis Labels'.
Highlight the correct range of cells in your worksheet that contains your category labels, then click 'OK' to apply them.
Disable the Secondary Horizontal Axis
Turn off the secondary horizontal axis so that all data series are forced to read from the primary horizontal axis.
Prepare an Anonymized Sample for Support
If complex chart-source settings prevent a quick fix, share an anonymized version of the workbook for advanced diagnosis.
Experience Hassle-Free Charting with WPS Office
Tired of complex axis settings changing your chart labels unexpectedly? Try WPS Office. It provides an intuitive, user-friendly interface for creating professional charts, including dual-axis combo charts, without the layout headaches. Plus, it's fully compatible with your existing Excel workbooks.
Frequently Asked Questions
Why do my Excel chart labels change when adding a secondary axis?
When a series is assigned to a secondary axis, Excel sometimes generates an independent secondary horizontal axis. If the new axis doesn't have an explicit label range assigned, it defaults to sequential numbers (1, 2, 3) or misaligns the existing categories.
How do I remove the top secondary horizontal axis from my Excel chart?
Click your chart, select the 'Chart Elements' (plus) icon, hover over 'Axes', click the right arrow, and uncheck 'Secondary Horizontal'. This will hide the top axis and force the chart to use the primary bottom axis.
Can I have different category labels for my primary and secondary axes?
Yes. You can enable the 'Secondary Horizontal' axis from the Chart Elements menu. Then, right-click the chart, choose 'Select Data', select your secondary series, and edit its 'Horizontal (Category) Axis Labels' to point to a different data range.
