Fix Negative Excel Chart Currency Labels Resetting from -£X to (£X)
Question details
The user wants to format negative currency labels on an Excel chart axis as -£X instead of (£X) and prevent the custom format from resetting when the workbook is saved and reopened.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Applying and retaining a custom number format for negative currency values on a chart axis.
- Observed behavior
- The custom number format works temporarily but reverts to the default (£X) accounting format after the workbook is saved, closed, and reopened.
Ensure your workbook is saved in a standard modern format like .xlsx, as older formats (.xls) or CSV files may not fully support or retain advanced chart formatting customizations upon saving.
Apply Custom Number Format Directly to the Chart Axis
Bypassing the source cell formatting and applying a custom format code directly to the chart axis ensures better stability when the file is saved.
By default, Excel charts often pull their number formats directly from the source cells. If the source cells use a standard Accounting format, negative numbers will display in parentheses. Unlinking the chart axis and forcing a custom format resolves this.
Click on the specific axis in your chart that contains the currency labels to highlight it.
Right-click the highlighted axis and choose 'Format Axis' from the context menu to open the formatting pane.
In the Format Axis pane, expand the 'Number' category at the bottom. Uncheck the box that says 'Linked to source'.
In the Format Code box, enter £#,##0;-£#,##0;£0 and click 'Add'. This forces positive numbers, negative numbers (with a minus sign), and zeroes to display precisely as defined.

Save as .xlsx and Test for File Corruption
If the formatting continues to reset after reopening the document, it may be due to file type limitations or workbook corruption.
Format Chart Axes Seamlessly in WPS Spreadsheet
WPS Office provides robust chart formatting tools that retain custom number formats like negative currencies perfectly without resetting upon save. It is fully compatible with your existing Excel files.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your .xlsx workbook containing the chart.
- 2. Access the Format Axis Window: Double-click the chart axis to instantly open the 'Format Axis' task window on the right side of the screen.
- 3. Unlink and Apply Custom Format: Navigate to the 'Number' tab, uncheck 'Linked to source', input £#,##0;-£#,##0;£0 in the Custom format box, and click Apply.
- 4. Save Your Progress: Press Ctrl + S to save. WPS Spreadsheet will reliably retain your custom axis formatting for the next time you open it.

Frequently Asked Questions
Why does my chart axis format automatically change to (£X)?
The default Accounting format in most spreadsheet software uses parentheses for negative numbers. If your chart axis is set to 'Linked to source', it will inherit this default formatting from the worksheet cells, overriding any manual changes you try to make on the chart itself.
What does the custom format code £#,##0;-£#,##0;£0 mean?
This code is divided into three sections separated by semicolons, telling the spreadsheet how to display positive numbers, negative numbers, and zeroes, respectively. The middle section '-£#,##0' explicitly forces negative numbers to display with a minus sign instead of the default parentheses.
How do I unlink my chart axis format from the source data?
To unlink the format, right-click the specific chart axis, select 'Format Axis', and expand the 'Number' section in the settings pane. Uncheck the box labeled 'Linked to source'. This allows you to apply a custom format to the chart without affecting the underlying cell data.




