Fix Excel Removes Secondary-Axis Labels and Tick Marks After Saving
Question details
Users need to restore or preserve secondary-axis tick marks and labels that disappear when a workbook is saved in Excel.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Saving an older .xls workbook that contains complex charts with a secondary axis, typically after a recent Microsoft 365 update.
- Observed behavior
- The secondary-axis tick marks and formatting labels are automatically removed or reset upon saving, closing, and reopening the .xls file.
Before attempting these fixes, verify your exact Excel version and save a backup copy of your original .xls workbook to ensure your underlying chart data remains safe.
Convert to .xlsx, Correct the Chart, and Re-import
Use the newer .xlsx format to retain the chart settings temporarily, then copy the fixed chart back into your original .xls file and update the references.
This method bypasses the saving bug associated with legacy formats in newer Excel updates by utilizing the stable .xlsx format to apply and lock in the correct formatting before porting it back to the .xls document.
Go to File > Save As, choose 'Excel Workbook (*.xlsx)' from the format drop-down menu, and save a new copy of your file.
Open the newly created .xlsx file. Right-click the chart's secondary axis, select 'Format Axis', and re-apply your desired tick marks and labels. Save the file.
Keep both the .xlsx and the original .xls files open. Copy the corrected chart from the .xlsx file, paste it into the original .xls file, and delete the old, corrupted chart.
Right-click the newly pasted chart in the .xls file and choose 'Select Data'. Edit the data series references to ensure they point to the data ranges within the current .xls workbook, then save.
Recreate the Chart in a Blank Workbook
If the existing chart is deeply corrupted, rebuilding it in a completely new file can resolve the saving issue, even if you still need to export it as an .xls file.
Create and Save Complex Charts with WPS Spreadsheet
WPS Office provides excellent compatibility with legacy .xls files and modern .xlsx formats. You can effortlessly add, customize, and safely save secondary-axis labels and tick marks without worrying about formatting drops.
- 1. Open your file: Launch WPS Spreadsheet and open your existing .xls or .xlsx document.
- 2. Select the chart elements: Click on the chart you want to modify, which activates the 'Chart Tools' ribbon at the top.
- 3. Assign a secondary axis: Double-click the specific data series on the chart to open the Series Options pane, and select 'Secondary Axis'.
- 4. Add tick marks and labels: Click the 'Add Chart Element' button (the plus icon) next to the chart to check off Axis Titles, Data Labels, and easily customize tick marks before saving.
Frequently Asked Questions
Why do my chart labels disappear when saving as an older .xls file?
The older Excel 97-2003 (.xls) format has limitations with newer charting features introduced in recent Microsoft 365 updates. This can cause compatibility conflicts where advanced visual settings, like specific secondary-axis ticks, fail to write properly and are dropped upon saving.
Can I permanently fix a corrupted chart without starting over?
Upgrading the file format to .xlsx usually resolves formatting bugs permanently. If your client strictly needs an .xls file, converting it to .xlsx, fixing the chart settings, and copying it back to the .xls file is the most reliable workaround.
How do I add a secondary axis to an existing chart?
Right-click the data series directly on your chart, select 'Format Data Series', and under the Series Options tab, toggle the axis setting from 'Primary Axis' to 'Secondary Axis'.
