Excel automatically inserts the graph, but it has no labels. Review the new green "Chart Tools" tab and ribbon at the top of the screen. If you don't see them, click the chart to enable them.

How to Add Notes to an Excel Chart. Microsoft Excel's quick-format chart and graph features offer a way to instantly convert your data-filled cells into a visual representation such as a pie chart ...

Now, to create a non-contiguous selection, select B3:B7, the counties. Hold down the Ctrl key and select E3:E7. To insert the filled map, click the Insert tab and then click Maps in the Charts group.