How to create a map chart in Excel

The key steps in creating a map chart in Excel include: preparing data containing standard geographic names and corresponding values, ensuring that you use an Excel version that supports map functionality, insert map charts and style optimization. First, the data must include standard English region names and values, such as "China" and "Beijing". You can use the "Convert" function or manually replace the Chinese name; secondly, use Excel 2016 and above versions, select the data and select "Fill Map" or "Bubble Map" in "Insert"-"map"; finally, adjust the color, label, display area and map viewing angle through the "Character Tool" to make the chart clear and intuitive.

Creating maps and charts is not actually complicated in Excel, but many people are not very familiar with this feature. If your data is related to geographical location, such as sales distribution, demographic statistics, etc., maps and charts can visually display the situation in different regions. The key is to prepare the data, select the right chart type, and ensure that the Excel version supports map functionality.

Data preparation is key

The basis of map charts is to have clear geographical indication information. Your data table should at least include the region name (such as country, province, city) and corresponding values (such as sales, quantity, etc.). Note that if these regional names are standard names that Excel can recognize, such as "China" instead of "China", or "Beijing" instead of "Beijing", otherwise the map may not match correctly.

For example:

 | Region | Sales |
|-------------|--------|
| China | 10000 |
| USA | 15000 |
| Germany | 8000 |

If your data is a Chinese region name, you can first try to automatically identify it with Excel's "Convert" function, or manually replace it with the English standard name. Also, don't have too much data range, otherwise the map may appear confusing.

Steps to insert a map chart

Excel's map chart function is in the Chart area under the Insert tab, but not every version has it. Make sure you are using Excel 2016 and above, or Office 365 version.

The operation steps are as follows:

• Select your data area (including region and value)
• Click "Insert" in the menu bar
• Find the Map category in the Chart area
• Select "Fill Map" or "Bubble Map" to decide according to your needs

After inserting, Excel will automatically match your data to the map. If some areas do not display, check if the name is correct, or try to adjust it manually.

Map style and display optimization

After the map is inserted, some adjustments may be required to look clear and intuitive.

You can use the "Character Tool" to:

• Modify the color gradient to make the numerical difference more obvious
• Add data labels to facilitate viewing of specific values
• Adjust the display area of the map, such as only Asia or Europe
• Switch map type, such as switching from national level to provincial level (provided that data support)

A small detail that is often overlooked is the projection direction of the map. Some maps are "Arctic Perspective" by default, which doesn't look very intuitive. You can right-click the map and select "Set Map Area" to adjust the viewing angle direction.

Basically that's it. Although map charts are not the most commonly used type in Excel, they are very practical when presenting geo-distributed data. As long as the data is prepared properly, it is not difficult to operate.

The above is the detailed content of How to create a map chart in Excel. For more information, please follow other related articles on the PHP Chinese website!