Home>Blogs>Charts and Visualization>Dynamic Filled map in Excel
Dynamic Filled Map
Charts and Visualization

Dynamic Filled map in Excel

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

Youtube.com/@PKAnExcelExpert

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"
Data type as “Geography”
  • Select the State and Sales column.
  • Go to insert tab>>Charts>>Maps>>Insert filled map
Insert filled map
Insert filled map
  • Select the table and insert Country and State Slicers.
Insert Slicers
Insert Slicers
  • Select the Chart and Slicers together using ctrl key and mouse.
Select Chart and Slicers together
Select Chart and Slicers together
  • 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
Add Data labels
  • 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
Format Data Series
  • Our Map is ready, If in the country slicer you will select India then our map will look like this-
India's Map
India’s Map
  • If in the country slicer you will select the United States then our map will look like this-
Filled map in Excel
Filled map in Excel

 

  • If we will select any state then change will be changed to the state level-
State level Map
State level Map

 

Click here to download the practice file.

PK
Meet PK, the founder of PK-AnExcelExpert.com! With over 15 years of experience in Data Visualization, Excel Automation, and dashboard creation. PK is a Microsoft Certified Professional who has a passion for all things in Excel. PK loves to explore new and innovative ways to use Excel and is always eager to share his knowledge with others. With an eye for detail and a commitment to excellence, PK has become a go-to expert in the world of Excel. Whether you're looking to create stunning visualizations or streamline your workflow with automation, PK has the skills and expertise to help you succeed. Join the many satisfied clients who have benefited from PK's services and see how he can take your Excel skills to the next level!
https://www.pk-anexcelexpert.com