How to Fix Excel Charts That Break When Adding a Secondary Axis
Question details
The user is experiencing chart corruption and missing axes when attempting to move a data series to a secondary axis.
- Product
- Excel
- Device & OS
- Windows and Mac
- Scenario
- Moving a data series to a secondary axis to visualize mixed data sets with different numerical scales.
- Observed behavior
- Adding a secondary axis causes other data series to compress, the secondary axis disappears, and the chart visual becomes corrupted.
Before modifying your chart settings, ensure that your source data contains distinct ranges with significantly different numerical values, which justifies the use of a secondary axis without skewing the primary data scale.
Verify Data Selection and Chart Type Assignments
Check the data ranges and chart type settings to ensure the secondary axis is properly assigned to the correct series without conflicting chart types.
Chart corruption often occurs when two series on different axes share the exact same chart type (like Clustered Column), causing visual overlaps and compression. Adjusting the combination usually resolves this.
Right-click the corrupted chart and select 'Select Data' from the context menu to view your data series.
Review the Legend Entries (Series) and source data ranges. Ensure they match your intended data sets and haven't been altered.
Right-click the chart again and choose 'Change Chart Type', then navigate to the 'Combo' chart section.
Check the 'Secondary Axis' boxes for the specific series you want on the second axis, and ensure compatible chart types (like combining Line and Column) are selected to avoid visual compression.
Easily Create Combo Charts with Secondary Axes in WPS Office
WPS Spreadsheet provides a highly stable and intuitive charting interface. You can effortlessly add a secondary axis to your charts without dealing with data compression or formatting glitches.
- 1. Insert a Chart: Select your data range, go to the 'Insert' tab, and choose your preferred base chart type.
- 2. Change to Combo Chart: Right-click the chart, select 'Change Chart Type', and click on the 'Combo' option in the sidebar.
- 3. Enable Secondary Axis: In the dialog box, simply check the 'Secondary Axis' box next to the desired data series, set it to a Line chart, and click OK.
Frequently Asked Questions
Why does my Excel chart compress when I add a secondary axis?
This typically happens if both data series are using the exact same chart type (like a clustered column) on different axes, causing them to overlap or compress. Changing one series to a Line chart usually resolves the visual overlap.
How do I make the secondary axis visible again?
Click on your chart, go to 'Chart Design' > 'Add Chart Element' > 'Axes', and ensure that 'Secondary Vertical' is checked.
Can a corrupted Excel workbook cause chart glitches?
Yes. If your charts frequently break or disappear despite correct settings, the workbook itself may be corrupted. Try copying your raw data into a fresh workbook to see if normal chart functionality is restored.
