How to Make a Filled Map Chart in Excel Tutorials

How to Make a Filled Map Chart in Excel

How to Make a Filled Map Chart in Excel

A Filled Map chart, is used to display high-level chart data within a map. Filled Maps are beneficial in visually displaying data sets by geographic location. This map type currently has significant limitations on the type of information it can display.

This tutorial will show you how to make and edit a Filled Map Chart in Excel

-->

How to Make a Filled Map chart in Excel

Step 1: Select the location data and change the data type to Geography

Use your mouse to select the location data you would like to include in your Filled Map Chart.

Step 1: Select the data you want displayed in the Column chart

Next, click the Data Tab, and then click the Geography Symbol in the Data Types Group. This step is critical in preparing your data to work with the map chart.

Step 2: Click the Insert Tab, and then Click the Column Symbol in the Charts Group

The locations in each cell will now be connected to bing maps and you will see a new Show Card symbol appear in each cell that was updated.

Step 2: Click the Insert Tab, and then Click the Column Symbol in the Charts Group

Step 2: Select the Data to be included in the Map Chart

Use your mouse to select the location data you would like to include in your Filled Map Chart.

Step 2: Click the Insert Tab, and then Click the Column Symbol in the Charts Group

Then click on the Insert Map Chart button in the Charts section on the ribbon, then the Insert Map Chart window will appear in the workbook.

Step 2: Click the Insert Tab, and then Click the Map Symbol in the Charts Group

Step 3: Click the Filled Map button from the Insert Map Chart window.

Click the Filled Map button from the Insert Map Chart window, then the chart will appear in the workbook.

Step 3: Click the Filled Map button from the Chart type window

Result: Your Map Chart will appear on your worksheet

You will now see your map chart appear in your worksheet. Now you can start adding chart elements and formatting to your chart. Continue reading for more details on adding chart elements and chart formatting.

Line Graph


How to Add Chart Elements to a Filled Map chart in Excel

Step 1: Click on a blank area of the chart

Use the cursor to click on a blank area on your chart. Make sure to click on a blank area in the chart. The border around the entire chart will become highlighted. Once you see the border appear around the chart, then you know the chart editing features are enabled.

Step 1: Click on a blank area of the chart

Step 2: Click on the Chart Elements button next to the chart

Once the chart name area is highlighted, you will see the Chart Elements button next to upper right hand side of the chart. The button looks like a plus sign. Doing this will open the Chart Elements window.

Step 2: Click on the Chart Elements button next to the chart

Step 3: Check the Chart Elements you would like to add from the Chart Elements window

Once you have opened the Chart Elements window, you will see a number of items you can select to add to your chart. Check the Chart Elements you would like to display and they will appear on your chart. You can click on the arrow next to each Chart Element option for some additional formatting options.

Step 3: Select Axis Titles from the Chart Elements window

Here are the available chart elements for a Filled Map Chart:

  • Chart Title
  • Data Labels
  • Legend

Each of these chart elements can be formatted in a variety of ways. Please see our other tutorials on how to add and format each chart element.

How to Format a Filled Map chart in Excel

Step 1: Right-Click on a blank area of the chart

Use the mouse to right-click on a blank area on your chart. On the menu that appears select the Format Chart Area option.

Step 1: Right-Click on a blank area of the chart

Step 2: Select the Format Chart Area option

On the menu that appears select the Format Chart Area option. Doing this will open the Format Chart Area panel on the right side of the workbook.

Step 2: Select the Format Chart Area option

Step 3: Use the Format Chart Area panel to make changes to the appearance of your chart

Once you have opened the Format Chart Area panel, you will see a number of items you can modify on your chart. use these features to create a custom look for your Filled Map chart.

Step 3: Use the Format Chart Area panel to make changes to the appearance of your chart

Here are the available chart elements for a Filled Map Chart:

  • Fill
  • Border
  • Shadow
  • Glow
  • Soft Edges
  • 3-D Format
  • Size
  • Properties

Please note: You can also right click on any of your chart elements and open a separate formatting panel for that particular item. The Format Chart Area panel will be the one you want to use when formatting the main structure of the chart.

Next Topic

How to Make a Stock Chart in Excel




Thanks for checking out this tutorial. If you need additional help, you can check out some of our other free Excel Chart Tutorials, or consider taking an Excel class with one of our professional trainers.