How to create a geographical map chart in Microsoft excel?
2 min readDec 29, 2022
First of all please note that this feature was introduced in Excel 2016, so if you are using an earlier version, you will not have access to this option.
Here is a step-by-step guide on how to create a map chart in Excel:
- Open your Excel workbook and select the data that you want to use for the map chart. Make sure that the first column contains the names of the regions or countries that you want to include on the map, and the second column contains the data that you want to visualize.
- Click on the “Insert” tab in the ribbon, and then click on the “Map” chart option in the “Charts” group.
- A new map chart will be inserted into your worksheet. By default, Excel will use the first column of data as the labels for the map, and the second column as the data values.
- If you want to customize the appearance of the map, you can use the options in the “Design” and “Format” tabs in the ribbon to change the colors, labels, and other aspects of the chart.
- If you want to change the data that is displayed on the map, you can simply select the map chart and then click on the “Select Data” button in the “Design” tab. This will open the “Select Data Source” dialog box, where you can edit the data that is used to create the map chart.
- When you are finished customizing your map chart, you can click the “Close” button to close the “Select Data Source” dialog box and return to your worksheet. The map chart will be updated to reflect your changes.
If you enjoyed this content and would like to stay up-to-date with my latest thoughts and updates, please consider following me here and on Twitter at https://twitter.com/EliasHoyek.
If you’re a tech enthusiast who loves staying up-to-date on the latest computer science and technology trends, we’d be honored if you’d consider giving our Facebook pages a like. We promise to keep you informed and entertained with engaging content and discussions on all things tech!
