An area chart is a bar chart with color-filled areas. Use a stacked area chart to show the contribution of each value to the total over time or across categories.
To create an area chart, follow these steps:
- Highlight a range A1:D7.
- On the Advanced tab Insert (Insert) in section Diagrams (Charts) click Insert an area chart > with areas (Area > Area). Result: In this example, some areas overlap each other.
The figure below shows the corresponding chart with markers so you can see it clearly.
- Change the Chart Subtype on With areas and accumulation (Stacked Area).Result:
Note: If you are using number captions, clear the cell A1 before creating an area chart. In this case, Excel will not accept the column A as a data series and will automatically place the number labels along the horizontal axis. If necessary, after creating the chart, you can enter a title in the cell A1.