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 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


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


Bill Jelen is the author / co-author of
Excel Dynamic Arrays Straight to the Point 2nd Edition

Fifteen months after Dynamic Arrays debuted for Office Insiders, the functions are being released to General Availability. This second edition of the book has been updated with new examples: see how Dynamic Arrays make XLOOKUP better. The chapter on the logic behind arrays has been expanded.