Microsoft Excel Tutorial: Use 3D Maps to summarize city data at the state level.

Got sales data by city but need to display it by state in Excel’s 3D Maps? A.K. asked if there’s a way to sum sales at the state level instead of individual cities—yes, and it’s easy to do! In this tutorial, I’ll walk you through the steps to modify your 3D Map to show sales totals by state.

By default, Excel’s 3D Map plots data at the city level. If you want to switch to state-level mapping, simply adjust the location field to use State instead of City. But instead of Excel’s default column representation, I’ll show you a better way—using a Region Map to shade states based on total sales. This makes your data much easier to analyze at a glance.

Need to show both cities and states? No problem! You can add a second layer to the 3D Map, keeping city data while still displaying state-level totals. I’ll also show you how to tweak the visuals to avoid clashing colors and create a more polished, professional-looking map.

This method provides a clearer picture of sales performance across different locations, helping you make better business decisions. Whether you’re analyzing regional trends or just want a better way to present your data, these Excel 3D Map tricks will come in handy.

If this video helped, LIKE, SUBSCRIBE, and COMMENT with your Excel questions! Thanks to A.K. for the great question—see you in the next episode of MrExcel!

Buy Bill Jelen’s latest Excel book: https://www.mrexcel.com/products/latest/

Table of Contents
(0:00) Changing Excel 3D Map from City to State
(0:18) New 3D Map is at City level by default
(0:44) Choices – replace city or add new layer
(0:54) Changing City to State
(1:05) Changing to Region
(1:23) Adding a second layer for State or City
(1:40) Changing Column Color in Excel 3D Map
(2:06) Wrap-up