Area Chart in Excel (Tables of Contents)
Area Chart in Excel
We go through lots of data in our daily life, be it college or jobs. When we manage multiple contents of data it may get overwhelming. The main solution arises is the visualization of the data. How do you visualize and analyze the data so you can extract insights and actionable information?
Choosing the wrong form of visualization may lead to incorrect interpretation of data. Charts in excel are useful in the correct interpretation of data. However, there are many types of charts for their specific uses. In which the most common one is Area Chart.
What is an Area Chart in Excel?
Simply put, area chart displays graphically quantitative data. Let’s go deeper into the definition. It is online based chart where the area between the axis and line are bifurcated with different colors and textures. The representation of data through area chart is more understandable and distinctive. This chart is useful for showing part to whole relations. Also, it helps to analyze overall and individual trend relation.
How to make an Area chart in Excel?
Now we have understood let’s dig deeper and see how to make an area chart in excel.
We have the above data of a student’s marks scored in his exams.
Steps to make an Area Chart in Excel:
- Select the data in excel.
- Then go to insert tab in your excel workbook there is a chart section and click on all charts.
- After that, you can find the fifth type of chart as “AREA”. Select the first one and then click OK.
The chart will look like:
In the above-mentioned chart, Y-axis is the representation of marks whereas the X-axis is the representation of subjects.
Let us practice a few more examples.
Example #1
There is a canteen which sells the following products { Pizza, Sandwich, Tea, Coffee & Burger}, the vendor has data of his sales for the month of Jan, Feb & March. He wants to make an area chart so that the owner of the canteen can have quick visualization for the sales in the quarter.
Below is the representation of the raw data in excel,
Let’s follow the same steps and go to insert tab and then in chart section select all charts.
After that, you can find the fifth type of chart as “AREA”. Select the first one and then click OK.
As soon as you insert the chart, it will look like this.
Right click on the Plot chart and click on select data.
And then click on Switch Row/Column.
After switching, the chart will look like this.
Right click on Legend and select Format Legend.
Go to Legend Options and select Bottom.
After that our Chart looks like this.
For Adding chart title. We have to click on Layout > Chart Title > Above Chart.
Our Final Chart looks like this.
As the definition follows, the chart distinguishes data in colors and textures. All the products are in different color from one another and the area occupied by them shows the number of sales done.
Example #2
Anand is a bachelor and he wants to see what was his spending for the past three months in terms of Food, Rent, Electricity Bill, Travel Charges and Miscellaneous Expenses.
Below is the representation of raw data in excel,
Again, follow the same steps and go to insert tab and then in chart section select all charts.
After that, you can find the fifth type of chart as “AREA”. Select the first one and then click OK.
As soon as you insert the chart, it will look like this.
Uh-oh, we cannot judge the spending of Anand did for the past three months from this area chart. No worries the above chart is a 2-D or two-dimensional chart.
In the Area chart, there is another choice for 3-D charts as well.
The above image shows a clear picture of the data. Therefore, it is easier to look at the spending’s which Anand did for the past three months from 3-D Area chart.
Example #3
We also learned that this chart could show overall or individual trends. For an example in a Company A, B, C & D are working and the boss wants to review their performance for the three quarters passed in this year.
Let us take a look at the raw data,
And we follow the same steps and go to insert tab and then in the chart section select all charts,
After that, you can find the fifth type of chart as “AREA”. Select the first one and then click OK.
As soon as you insert the chart, it will look like this.
The above image is a pictorial representation of the overall analysis of the employees for their respective quarters.
Along with the various uses of the Area chart, there are some Pros and Cons to it. Let’s discuss it one by one,
Pros:
- It represents relatively simple data in a quantitative format.
- It compares only a small number of categories.
Cons:
- It is difficult to read as compared to other charts.
- Reading the exact values from this chart is not feasible.
- If I need to cover multiple sections and want to know the exact data values then it would not be a feasible option.
Things to Remember About Area Chart in Excel
- Use transparent colors so that the information is not obscured in the background.
- Do not display excessive categories to avoid clutter.
- Organize highly variable data on the top of the chart to make it easy to read.
Recommended Articles
This has been a guide to Area Chart in Excel. Here we discuss how to make Area Chart in Excel along with excel examples and downloadable excel template. You may also look at these suggested articles:
