Chart & Visualization Issues

How to Display Integer Values in Excel 3D Maps Data Cards

Amos GikundaAmos Gikunda Oct 22, 2026 871 views

Question details

The user needs a way to display numbers as whole integers or formatted currency within Excel 3D Maps data cards.

How to Display Integer Values in Excel 3D Maps Data Cards
Product
Microsoft Excel
Device & OS
not provided
Scenario
Creating an Excel 3D Map visualization where the data cards need to show clean, whole numbers instead of raw, unformatted decimal values.
Observed behavior
Excel 3D Maps data cards ignore custom currency or number formatting applied to cells and display long, unformatted decimal values by default.
Before you start

Make sure you have editing access to the original dataset in your spreadsheet, as you will need to modify the source data before launching the 3D Map.

Solution 1Recommended

Use the TRUNC Function to Remove Decimal Places

Because 3D Maps cannot format numbers directly, you must use the TRUNC function in your source data to strip away decimals before creating the visualization.

The TRUNC function truncates a number to an integer by removing the fractional part of the number. This is the most direct way to ensure your 3D Map data card displays a clean integer.

1
Create a helper column

Insert a new column next to the original decimal data in your Excel worksheet.

2
Apply the TRUNC formula

Select the first empty cell in the new column and type =TRUNC(B2, 0) (replace B2 with the cell reference of your original data).

3
Fill the formula down

Press Enter, then click and drag the fill handle at the bottom-right corner of the cell to apply the formula to all rows in the dataset.

4
Update the 3D Map

Open your 3D Map and update the Layer Options to map this new integer column to your data card instead of the original raw data.

Use the TRUNC Function to Remove Decimal Places
Data Format Updated: Your 3D Map data card will now display whole numbers without trailing decimals.
Free Microsoft Office alternative

Experience Seamless Data Visualization with WPS Office

Avoid complex formatting limitations and high subscription costs. WPS Office provides a free, lightweight suite that seamlessly handles your spreadsheets and data visualizations, maintaining full compatibility with Microsoft Office files.

Fully compatible with Microsoft Excel (.xls, .xlsx) files and standard spreadsheet formulas.Rich library of built-in 2D and 3D charts for professional and highly customizable data visualization.Lightweight software architecture ensures fast startup and smooth handling of large datasets.Familiar ribbon interface ensures zero learning curve when migrating from Microsoft Office.
microsoft office alternative - wps office

Frequently Asked Questions

Can I format numbers as currency directly inside the Excel 3D Maps data card?

No, Excel 3D Maps data cards do not currently support applying custom number or currency formatting directly within the add-in. You must modify the values in the source worksheet to reflect the exact characters or integers you want displayed.

Why does my 3D Map data card show long decimal numbers instead of the formatted cell value?

The data card pulls the underlying raw values from your dataset rather than their formatted appearance. If the source cell contains decimals, the data card will display them regardless of whether the cell is visually formatted to hide decimals in the worksheet.

Will the INT function work instead of TRUNC or ROUND?

Yes, you can use the INT function (e.g., =INT(A2)) in your source data. It rounds numbers down to the nearest integer, which will effectively produce whole numbers that display properly on your 3D Map data card.