Area Chart

 

An area chart is a line chart with the areas below the lines filled with colors. Use a stacked area chart to display the contribution of each value to a total over time.

To create an area chart, execute the following steps.

1. Select the range A1:D7.

2. On the Insert tab, in the Charts group, choose Area, and select Area as subtype.

Select Area

Result. In this example, some areas overlap.

Area Chart in Excel

Below you can find the corresponding line chart to clearly see this.

Line Chart in Excel

3. Change the chart's subtype to Stacked Area (the one next to Area).

Result:

Stacked Area Chart in Excel

Note: only if you have numeric labels, empty cell A1 before you create the area chart. By doing this, Excel does not recognize the numbers in column A as a data series and automatically places these numbers on the horizontal (category) axis. After creating the chart, you can enter the text Year into cell A1 if you like.

6/18 Completed! Learn much more about charts >
Back to Top: Area Chart   |   Go to Next Chapter: Pivot Tables