Share via

Map Chart not showing all values?

Anonymous
2025-01-30T16:56:43+00:00

Trying to create a Map that shows values by state. For some reason, the chart only shows the values of 3 or 4 states/provinces. I saw another similar question where the response said to choose "category map", but I only have an option to select Filled Map.

Screen shot below.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-02-09T02:45:55+00:00

    Hello SDPBC,

    Thank you for supporting Microsoft products and posting in the community.

    I understand that you are experiencing an issue with your Excel map chart not displaying all values. Here are some possible reasons and solutions you can check:

    1. Data Format Issue: Ensure your data format is correct, including columns for geographic information such as city, country, or postal code. Make sure all geographic data is in separate columns, such as "State" and "Country" being separate.
    2. Geographic Data Type: Use Excel's geographic data type feature to generate map charts more easily. Enter a list of geographic values (e.g., country/region, state/province, county, city, postal code), then select the list and go to the "Data" tab > "Data Types" > "Geography". Ensure your data type settings are correct.
    3. Disambiguation: If using data that may have multiple similar locations globally, the map chart may not recognize the differences. Add higher-level detail columns to the data, such as state/province. Add more detailed geographic information.
    4. Excel Version: Ensure you are using the latest version of Excel, as some features may not be available in older versions. Make sure your Excel is up to date.

    Thank you for your patience, and I hope this information helps you.

    Best regards,

    Ian - MSFT | Microsoft Community Support Specialist

    0 comments