Chart & Visualization Issues

Fix Negative Excel Chart Currency Labels Resetting from -£X to (£X)

Olivia MillerOlivia Miller Oct 14, 2026 870 views

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.

How to Keep Negative Excel Chart Labels in -£X Format
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the Chart Axis

Click on the specific axis in your chart that contains the currency labels to highlight it.

2
Open Format Axis Pane

Right-click the highlighted axis and choose 'Format Axis' from the context menu to open the formatting pane.

3
Unlink from Source Data

In the Format Axis pane, expand the 'Number' category at the bottom. Uncheck the box that says 'Linked to source'.

4
Enter Custom Format Code

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.

Apply Custom Number Format Directly to the Chart Axis
Beware of Chart Styles: Applying a preset chart design or style from the ribbon after setting this custom format will likely override your axis settings. Always apply your custom number format as the final step in designing your chart.
Professional Spreadsheet Tool

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. 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your .xlsx workbook containing the chart.
  2. 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. 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. 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.
Easily apply and retain custom number formats for charts and cells.Fully compatible with Microsoft Excel formats including .xls and .xlsx.Rich built-in chart templates and advanced customization options.Lightweight, fast, and completely free to download.
microsoft office alternative - wps office

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.