EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Charts Excel Area Chart
Secondary Sidebar
Excel Functions
  • Excel Charts
    • Excel Data Visualization
    • Dashboard in Excel
    • Bullet Chart in Excel
    • Excel Animation Chart
    • Plots in Excel  
    • Interactive Chart in Excel
    • Surface Charts in Excel
    • Excel Calendar Template
    • Thermometer Chart in Excel
    • Box Plot in Excel
    • S CURVE in Excel
    • Venn Diagram in Excel
    • Project Management with Gantt Chart
    • Change Chart Style in Excel
    • 3D Scatter Plot in Excel
    • Box and Whisker Plot in Excel
    • Radar Chart in Excel
    • Control Charts in Excel
    • Dot Plots in Excel
    • Marimekko Chart Excel
    • Combo Chart in Excel
    • Contour Plots in Excel
    • Candlestick Chart in Excel
    • Map Chart in Excel
    • Pie Chart Examples
    • Excel Stacked Bar Chart
    • Excel Flowchart
    • Excel Types of Graphs
    • Excel Normal Distribution Graph
    • Excel Bell Curve
    • Legends in Excel Chart
    • Excel Chart Templates
    • Excel Organization Chart
    • Excel Doughnut chart
    • Excel 3D Plot
    • Excel Scatter Chart
    • Excel Line Chart
    • Excel Combination Charts
    • Excel Gauge Chart
    • Excel Pivot Chart
    • Excel Clustered Column Chart
    • Excel Dynamic Chart
    • Excel Stacked Column Chart
    • Excel Bubble Chart
    • Histogram Chart Excel
    • Excel Gantt Chart
    • Excel Stacked Area Chart
    • Excel Waterfall Chart
    • Excel Area Chart
    • Excel Clustered Bar Chart
    • Excel Column Chart
    • Excel Pie Chart
    • Comparison Chart in Excel
    • Pareto Analysis in Excel
    • Add a Secondary Axis in Excel
    • Grouped Bar Chart
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED COURSE
  • Excel Data Analysis Course
  • Excel for Marketing Course

Excel Area Chart

By Madhuri ThakurMadhuri Thakur

Area Chart in Excel

Area Chart in Excel (Tables of Contents)

  • Area Chart in Excel
  • How to make an Area chart in Excel?

Area Chart in Excel

Area Chart is available in 3D and 2D types in excel under the insert menu tab. An area chart can be used in various situations where we need to show how much certain points cover an area or population. The area chart actually is formed by lines that show different parameters and their trend, and the area under these lines are shows the actual coverage of how much area is covered by the selective points. We may have simple parameter points, but Area Chart looks more attractive and meaningful using different colours if we have more than one parameter to show.

What is an Area Chart in Excel?

Simply put, the area chart displays graphically quantitative data. Let’s go deeper into the definition. It is an online-based chart where the area between the axis and line is bifurcated with different colors and textures. The representation of data through an area chart is more understandable and distinctive. This chart is useful for showing the part to whole relations. Also, it helps to analyze overall and individual trend relations.

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.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

You can download this Area Chart Excel Template here – Area Chart Excel Template

Area chart Step 1

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.

Select data

  • Then go to the insert tab in your excel workbook; there is a chart section and click on all charts.

Click on all charts

  • After that, you can find the fifth type of chart as “AREA”. Select the first one and then click OK.

Select Area

The chart will look like this:

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,725 ratings)

Chart Output

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 canteen owner can have quick visualization for the sales in the quarter.

Below is the representation of the raw data in excel,

Example 1

Let’s follow the same steps and go to the insert tab and then in the chart section, select all charts.

Area chart Example 1-2

After that, you can find the fifth type of chart as “AREA”. Select the first one and then click OK.

Area chart Example 1-3

As soon as you insert the chart, it will look like this.

Area chart Example 1-4

Right-click on the Plot chart and click on select data.

Area chart Example 1-5

And then click on Switch Row/Column.

Area chart Example 1-6

After switching, the chart will look like this.

Area chart Example 1-7

Right-click on Legend and select Format Legend.

Area chart Example 1-8

Go to Legend Options and select Bottom.

Area chart Example 1-9

After that, our Chart looks like this.

Area chart Example 1-10

For Adding chart title. We have to click on Layout > Chart Title > Above Chart.

Area chart Example 1-11

Our Final Chart looks like this.

Result of Example 1

As the definition follows, the chart distinguishes data in colours and textures. All the products are in a different colour 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,

Example 2

Again, follow the same steps and go to the insert tab and then in the chart section, select all charts.

Area chart Example 2-2

After that, you can find the fifth type of chart as “AREA”. Select the first one and then click OK.

Area chart Example 2-3

As soon as you insert the chart, it will look like this.

Area chart Example 2- 4

Uh-oh, we cannot judge Anand’s spending 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.

Result of Example 2

The above image shows a clear picture of the data. Therefore, it is easier to look at the spending which Anand did for the past three months from the 3-D Area chart.

Example #3

We also learned that this chart could show overall or individual trends. For 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,

Example 3

And we follow the same steps and go to the insert tab and then in the chart section select all charts,

Area chart Example 3-2

After that, you can find the fifth type of chart as “AREA”. Select the first one and then click OK.

Area chart Example 3-3

As soon as you insert the chart, it will look like this.

Result of Example 3

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 know the exact data values, it would not be feasible.

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 a downloadable excel template. You may also look at these suggested articles:

  1. Excel Print Area
  2. Interactive Chart in Excel
  3. Surface Charts in Excel
  4. Comparison Chart in Excel
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Data Analysis Training (17 Courses, 8+ Projects)4.9
Excel for Marketing Training (8 Courses, 13+ Projects)4.8
1 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Area Chart Excel Template

EDUCBA

Download Area Chart Excel Template

EDUCBA

डाउनलोड Area Chart Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more