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

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

Bill Jelen is the author / co-author of
Microsoft Excel 2019 Inside Out

Dive into Microsoft Excel 2019–and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to make the most of Excel’s most powerful tools for analyzing data and making better decisions.