Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
Worth $20, Absolutely Free
An area chart can help you to present data in a better way.
It’s just like a line chart, but in an area chart, the area below the lines is filled with a color.
You can use an area chart to make a visual trend comparison of your data and to present a trend line for a time period.
In this tutorial, you will learn following things about area charts.
So, let’s get started.
Here, I am using the below dataset to create an area chart in excel.
We have 3 types of area chart in excel. You can use them as per your need. Let’s have a look at each of the type for better understanding.
A simple area chart.
You can use a simple area chart in excel when you want to compare two or more categories for a time period. It will help you to analyze the change in the figures over the time (Years, Months, Days).
In above area chart, I have compared two different categories for a particular time period. It makes the data simple in understanding & effective for presentation.
Analyze overall trend.
Stacked area chart is useful when you want to present relationship between two or more categories.
It can also help you to check the change in the total value over the time period (Years, Months, Days).
In above chart, there is a trend of two categories and along with that you can also check the trend of total value over the time.
Show percentage contribution.
100% Stacked area chart is used where you want to show the percentage contribution between two or more categories over the time (Years, Months, Days).
This will help you to analyze the change in the contribution of the categories.
In above chart, we have a trend of the percentage contribution of two categories over the time. You can use more than two categories if you need.
You can use either 2D or 3D type of area charts. These display options are available in all types of the area chart.
As I mentioned area chart is a perfect fit when you are presenting trends in your data. It’s useful for communicating time series relationships.
If you have any unique use of area charts please share with me in the comment box.