How to Fix Wrong Currency Formatting in Excel Charts
Question details
Users are experiencing an issue where financial charts display the wrong currency symbol (e.g., shekels instead of U.S. dollars), despite bank accounts and transactions being in the correct currency.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Viewing or creating financial charts linked to bank account data where the currency format automatically updates incorrectly.
- Observed behavior
- Charts display incorrect regional currency symbols based on system locale or IP address rather than the actual currency of the financial accounts.
Ensure your operating system's location and regional settings are up to date, as Excel often pulls default currency formats directly from the system locale.
Adjust System Regional and Currency Settings
Excel often uses your computer's system locale or IP-based location to determine the default currency in charts. Changing your system region will fix this globally.
Microsoft may override file-specific settings with location-based regional settings, especially on a Mac. Updating the system locale ensures all new charts default to your preferred currency.
Navigate to the Control Panel on Windows or System Settings/Preferences on your Mac.
Go to the 'Language & Region' or 'Time & Language' settings menu.
Check the 'Region' or 'Regional Format' setting and change it to the country matching your desired currency (e.g., United States for U.S. dollars).
Close and reopen your spreadsheet program to allow the new system default currency to apply to your charts.

Manually Format Currency in Tables and Charts
If changing the system settings is not possible or doesn't work, you can manually override the currency symbol directly within your spreadsheet file.
Customize Chart Currency with WPS Spreadsheet
Take full control of your financial data formatting. With WPS Spreadsheet, you can easily define exact currency symbols for your charts without relying on restrictive system region settings.
- 1. Open your file: Launch WPS Spreadsheet and open your financial data file.
- 2. Select your data: Highlight the cells or chart axis that require currency formatting.
- 3. Access Format Cells: Right-click the selection and choose 'Format Cells', then navigate to the 'Number' tab.
- 4. Set the Currency: Select 'Currency', pick your desired symbol from the drop-down list, and click OK.

Frequently Asked Questions
Why does my spreadsheet automatically change my currency to a foreign symbol?
Spreadsheet software often pulls the default currency symbol from your computer's system locale or infers it based on your IP address. If your system region is set differently than your bank data, it will default to the local currency.
Can I apply different currencies to different charts in the same spreadsheet?
Yes. You can independently format the source data cells or the specific chart axis by right-clicking, selecting 'Format Cells' or 'Format Axis', and assigning a specific currency symbol under the Number formatting options.
Does changing my currency format affect the actual numerical value?
No. Changing the currency format only alters how the number is displayed visually. The underlying numerical value used for calculations remains exactly the same.




