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.

This type of control is truly one of Excel’s most helpful features, because the drop-down list can be almost anything. In this case, we’ll use a list of color names at the sheet level.