MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2019: Create Filled Map Charts in Office 365


March 25, 2019 - by Bill Jelen

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

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 Unsplash.com


Bill Jelen is the author / co-author of
MrExcel LX – The Holy Grail of Excel Tips

A book for people who use Excel 40+ hours per week. Illustrated in full color.