The first element to focus on is the Layer Pane. When you first generate the 3D map, Excel will review your column headers and try to identify which column contains the geographical data you want ...

Indeed, you can use Excel to create heat maps for pretty much anything, from displaying your sports team's on-field strengths to showing how climate change is impacting temperatures over time.

If you're looking for the perfect way to visualize the stats and data that you have compiled, Google Sheets and Microsoft Excel can help. We'll show you how.

Displaying values on a map chart is more meaningful than handing someone a sheet of data. Thanks to Microsoft Excel's Geography data type, creating a map chart is easier than you might think.