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 to plot.

Microsoft Excel has more dataviz capabilities than you may realize. Find out how to make your data stand out with charts, PivotTables, sparklines, slicers and more.

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.

Supplementing spreadsheet data with visual representation aids the user in identifying trends and patterns that may not be evident otherwise.