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.

Enter the “ Column Column Chart ” in Microsoft Excel, a clever visualization technique that combines category-level data with overall totals to tell a more complete story.

The second Excel drop down list will display the representatives in that region. To the right, you see labels and formats in preparation for creating the Excel drop down list.