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.

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.