How to create a link to a map in Excel Figure A shows a simple data set with five Kentucky counties. We can use the Geography data type to populate the population file for us.

To create an area chart based on this data, do the following: 1. Click anywhere inside the data. 2. Click the Insert menu. 3. Click the Insert Line or Area Chart option in the Charts group.