Area Charts in Excel | Area Charts Example

Area Charts in Excel

Area charts are more similar to Line Charts. The one difference between Area Charts and Line chart is that in area chart the area below the line is displayed in a particular color. The series with less values are hidden behind the series with high values. However, this problem is not related to Stacked Area Chart or 100% Stacked Area Charts.

Area charts are also used to show trends over time. There are 3 types of Area chart both in 2-D Format and 3-D Format. They are Area Chart, Stacked Area Chart, 100% Stacked Area Chart. While displaying series for multiple data it is advisable to use the 3-D Format.

We can clearly see multiple series in Line chart where as that is not the case with Area Chart. Area Charts are used when we need to show a part – to- whole analysis, a simple comparison between the trends or series and not the values, to know the change in magnitude, compare small number of categories.

Tip: Use Transparent Color in the Area Chart as it will help us to see the less value trend hidden in the high value trend.

Step to Create a Area Charts in Excel

Step 1: Select the range of cells or Highlight the cells.

Area Charts - Data Example

Step 2: Go to the Insert Tab > Chart Group > Click on Area chart

Area Charts - Insert tab Select Area chart

Step 3: From the drop down menu, select Area Chart.

Area Charts - Select Area Chart

Step 4: Area charts will be inserted in your worksheet.

Area Charts

Note: To quickly create a chart based on the default chart type, select the data and then Press Alt + F1 or F11.

Hope you like our tutorial for more cool and amazing trick of excel Like our Excel Superstar Facebook Page and subscribe to our Excel Superstar YouTube channel. Excel Superstar is the leading online training company, which provides Online Excel Course in Hindi. Connect with us and become an Excel Superstar.