Excel 2020: Create Filled Map Charts in Office 365
March 19, 2020 - by Bill Jelen
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.
Title Photo: Arthur Edelman at Unsplash.com
This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly.