Fix Excel 3D Maps Not Displaying Data as Currency
Question details
The user needs to format summarized values in Excel 3D Maps as currency, but the 3D Maps data cards only display the values as plain numbers or integers.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Visualizing financial or sales data on a geographical layout using the Excel 3D Maps add-in.
- Observed behavior
- Excel 3D Maps ignores the currency format applied in the underlying source table, forcing summarized values on the data cards to appear strictly as unformatted numbers.
Verify that your original data table correctly utilizes the 'Currency' or 'Accounting' number format, as standard Excel charts will properly inherit this setting even if 3D Maps does not.
Use Alternative Visualizations and Submit Feedback
Since Excel 3D Maps currently lacks native support for currency formatting on data cards, use standard PivotCharts for financial presentations and submit a feature request to Microsoft.
At present, Excel 3D Maps has a known limitation where it only supports plain numbers for quantitative values. It extracts the raw numeric data from your worksheet but drops the currency formatting when generating the data card.
To properly present financial data with currency symbols, it is recommended to rely on standard Excel visualizations while requesting a fix from the development team.
Select your source data table, navigate to the Insert tab, and click PivotChart. This standard visualization will correctly display your geographical and financial data.
In your PivotChart Fields pane, click on your financial value field, select Value Field Settings, click Number Format, and choose Currency to ensure the dollar signs are visible.
Open Excel, click on the File menu, and select Feedback (or Help > Feedback). Choose 'I have a suggestion' to request improved currency formatting support for 3D Maps data cards.

Create Flawless Charts and Visualizations with WPS Office
If you are frustrated by formatting limitations in complex add-ins, consider using WPS Office. It provides a lightweight, highly compatible spreadsheet environment that makes it incredibly simple to build stunning, accurately formatted charts for your financial data.

Frequently Asked Questions
Why did my numbers lose the currency symbol in Excel 3D Maps?
Excel 3D Maps is designed to extract raw quantitative values from the source data for rendering. Unfortunately, it does not inherit or carry over the cell's specific 'Currency' or 'Accounting' display format to the data cards.
Can I force 3D Maps to show a currency symbol by changing the source data to text?
If you convert numbers to text to include a currency symbol (e.g., typing '$1,000' as text), 3D Maps will no longer be able to calculate or sum those values. It requires strict numeric data to plot heights and summaries.
Is there an update coming to fix currency formats in 3D Maps?
Microsoft updates its applications continually, but there is no specific timeline for this feature. The quickest way to prompt an update is for affected users to submit direct feedback via File > Feedback in Excel.




