In the article, You will learn how to create a dynamic filled map in Microsoft Excel. Filled Map is available with Office 365 subscription. You can display the Region, country, or state-level data in a filled map.
Visit our YouTube channel to learn step-by-step video tutorials
Watch the step by step video tutorial:
Dynamic Filled map in Excel
In the example, we have taken Sales Data as Country, State, and Sales in millions. You can change the data type as “Geography” available in the Data tab.
![Data type as "Geography"](https://www.pk-anexcelexpert.com/wp-content/uploads/2020/08/Dynamic-Filled-Map-1.jpg)
- Select the State and Sales column.
- Go to insert tab>>Charts>>Maps>>Insert filled map
![Insert filled map](https://www.pk-anexcelexpert.com/wp-content/uploads/2020/08/Dynamic-Filled-Map-2.jpg)
- Select the table and insert Country and State Slicers.
![Insert Slicers](https://www.pk-anexcelexpert.com/wp-content/uploads/2020/08/Dynamic-Filled-Map-3.jpg)
- Select the Chart and Slicers together using ctrl key and mouse.
![Select Chart and Slicers together](https://www.pk-anexcelexpert.com/wp-content/uploads/2020/08/Dynamic-Filled-Map-4.jpg)
- Cut (press Ctrl+X) the selected hart and Slicers and paste on new worksheet
- Chart the size of the chart, make it bigger.
- Click on Chart Elements button (+button) and check Data labels
![Add Data labels](https://www.pk-anexcelexpert.com/wp-content/uploads/2020/08/Dynamic-Filled-Map-5.jpg)
- Right-click on the chart and click on Format Data Series.
- In the data series window, select Map levels as “Best fit only”.
- In the series color, select Diverging (3-color) and fill Red, Amber, and Green in Minimum, Midpoint and Maximum respectively
![Format Data Series](https://www.pk-anexcelexpert.com/wp-content/uploads/2020/08/Dynamic-Filled-Map-6.jpg)
- Our Map is ready, If in the country slicer you will select India then our map will look like this-
![India's Map](https://www.pk-anexcelexpert.com/wp-content/uploads/2020/08/Dynamic-Filled-Map-7.jpg)
- If in the country slicer you will select the United States then our map will look like this-
![Filled map in Excel](https://www.pk-anexcelexpert.com/wp-content/uploads/2020/08/Dynamic-Filled-Map-8.jpg)
- If we will select any state then change will be changed to the state level-
![State level Map](https://www.pk-anexcelexpert.com/wp-content/uploads/2020/08/Dynamic-Filled-Map-9.jpg)