2D Map Chart

Zeeshan Haider 0 Reputation points
2023-01-31T19:06:40.88+00:00

I am using Office LTSC Pro Plus 2021 x64 Multilingual, installed a Week ago

Issue: Data tab > Data Types > Geography is not available in MSEXCEL and I am unable to create city name wise 2D Map chart, currently its only Province Or State Or Country wise?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,301 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,615 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. IoTGirl 2,961 Reputation points Microsoft Employee
    2023-01-31T22:39:11.4+00:00

    This answer was provided at https://answers.microsoft.com/en-us/msoffice/forum/all/does-excel-in-office-2021-include-stock-and/30454863-c8fd-4310-9c04-66a6ecd73738

    "The Stocks and Geography data types are not available in the 2021 version, they are only available in the 365 version, the free online version, and the Android and iOS apps."

    The poster mentions you can go to Data > Get Add-ins and find some options there but they are not built-In.

    1 person found this answer helpful.
    0 comments No comments

  2. Emily Hua-MSFT 27,461 Reputation points
    2023-02-01T07:15:41.95+00:00

    Hi @Zeeshan Haider

    Please refer to IoTGirl's reply, that Geography data types are not available in Office LTSC Pro Plus 2021.

    The image is from article "Excel data types: Stocks and geography".

    Capture2


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.