Chart & Visualization Issues

How to Fix Blank Data Cards in Excel 3D Maps

Rana Garcia Oct 9, 2026 868 views

Question details

Users experience blank data cards in Excel 3D Maps where mapped lines fail to display the associated information from the source data.

How to Fix Blank Data Cards in Excel 3D Maps

Product: Microsoft Excel
Device & OS: not provided
Scenario: Clicking on map lines or data points within an Excel 3D Map to view detailed information.
Observed behavior: The data cards appear completely blank instead of displaying the relevant values and categories from the source dataset.

Before you start

Before troubleshooting your 3D Maps, ensure your source data is formatted correctly as an Excel Table and that no active filters are hiding rows in your worksheet.

Solution 1Recommended

Verify Source Data and Refresh the 3D Map Layer

Check your dataset for inconsistencies and ensure the correct columns are actively mapped to the 3D Map fields.

Blank data cards typically occur when the 3D Maps layer loses connection to specific columns in the source data, or when the dataset contains empty cells, formatting errors, or invalid geographic locations.

Check for blank cells and inconsistencies

Review your source Excel Table. Ensure that all mapped columns are fully populated and do not contain mixed data types (e.g., text mixed with numbers).

Verify geographic data mapping

Ensure your location data (such as City, State, or Zip Code) is valid and correctly categorized in the 'Location' field list within the 3D Maps pane.

Re-add layer data fields

In the 3D Maps Layer Pane, verify that the required columns are actively added to the 'Height', 'Category', or 'Time' sections. Try removing them and adding them back.

Refresh or recreate the layer

Click 'Refresh Data' in the 3D Maps ribbon. If the cards remain blank, delete the current layer and create a new one using the corrected source table.

Verify Source Data and Refresh the 3D Map Layer

Sharing Files for Support: If you are sharing the workbook for troubleshooting with Microsoft Support or IT, ensure you share the file via a permitted private channel, especially if the file requires an organizational account.

Free Microsoft Office alternative

Try WPS Office for Seamless Data Visualization

If you frequently encounter stability issues with heavy Excel add-ins like 3D Maps, consider switching to WPS Office. It provides a lightweight, highly compatible, and user-friendly spreadsheet environment for all your daily data analysis and charting needs.

1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
2. Open your dataset: Launch WPS Spreadsheet and easily open your existing .xlsx workbooks.
3. Visualize your data: Select your data and use the 'Insert' tab to choose from a wide variety of reliable built-in charts.

Free and lightweight spreadsheet alternativeSeamless compatibility with Microsoft Excel (.xlsx) formatsRich built-in 2D charts and data visualization toolsFamiliar user interface requiring zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why are my Excel 3D Maps not showing any locations at all?

This usually happens if your location data is not categorized properly. Ensure that the columns containing geographical data are mapped to the correct geographic types (like City, State, or Country) in the 3D Maps Layer Pane.

Can hidden or filtered columns cause blank data cards in 3D Maps?

Yes, if the columns feeding into your 3D Map layer are hidden or filtered out in the source worksheet, the map may fail to process and display the information. Clear all filters and unhide columns before clicking 'Refresh Data'.

How do I manually refresh the data in Excel 3D Maps?

Open your 3D Maps window, navigate to the Home tab on the top ribbon, and click the 'Refresh Data' button. This forces the map to pull the most recent updates and corrections from your source Excel workbook.

Excel & Data Problems