The values in the table represent the number of permits.
The first column contains the y-axis label (year) with a column for each region. The following data set shows total permits issued (in thousands) for each region by year. In this example, we'll use a data set which shows annual building permits by region for single unit homes in the US from 2001 through 2016. To create a stacked area chart where the values are split into sub-groups, create a column for each of the sub-groups.
The first column should contain the labels and the second column contain the values. The easiest way to create an area chart in Excel is to first set up your data as a table.
In this post, we'll explore how to create a standard area chart, as well as a stacked area chart, in Excel.ĭon't forget though, you can easily create an area chart for free using Displayr's free area chart maker! Setting up the data for the area chart An area chart is based on a line chart, with the area between the line and the x-axis colored to illustrate volume.
