MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2020: Create Filled Map Charts in Office 365

March 19, 2020 - by Bill Jelen

Excel Create Filled Map Charts in Office 365. Photo Credit: Arthur Edelman at

Early in 2017, Map Charts appeared on the Insert tab in Office 365. A Map chart shades closed regions on a map such as countries, states, counties, even zip code boundaries.

When you format a series in a Map, you can choose if it should show all 50 states or only the regions with data. Choose what makes the most sense for your data. In the chart on the left, the series color is a two-color gradient. You can choose three-color gradients or a category map, as shown on the right.

This filled map chart shows the states of Ohio, West Virginia, Virginia, North Carolina, South Carolina, Georgia, and Florida. Each state is lighter or darker based on the number associated with the state. In this particular chart, it is the number of miles logged in each state when driving from Akron  Ohio to Cape Canaveral.  You spend 180 miles in WV, SC, and FL but only 50 miles to cross the narrow part of western Virginia.

Title Photo: Arthur Edelman at

This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly.

Bill Jelen is the author / co-author of
MrExcel 2020 - Seeing Excel Clearly

This is a 4th edition of MrExcel LX. Updates for 2020 include: Ask a question about your data, XLOOKUP, Power Query's Data Profiling tools, How Geography Data Types decide which Madison, A SEQUENCE example for descending 52 weeks, Exchange Rates support in Stock Data Types, How to collapse the Search box, How to leave effective feedback for Microsoft, How to post your worksheet to the MrExcel Board using XL2BB.