EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Charts Stacked 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 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

Stacked Area Chart

By Arun GuptaArun Gupta

Excel Stacked Area Chart

Excel Stacked Area Chart (Tables of Contents)

  • Stacked Area Chart
  • How to make Excel Stacked Area Chart?

Stacked Area Chart

A stacked Area Chart is a type of Area Chart which is available under the Insert menu tab with the name 100% Stacked Area. This chart shows the actual covered data from the total selected area. For example, we have 3 types of population data for 5 years which is for Infants, Kids, and Teens, so if we used the Stacked Area Chart here, we would be able to see how much area is of the population are covered by each of the categories for each year.

It can be used to represent: Ranking, Distribution, Comparisons, Part-to-whole, etc.

 A Stacked Column excel have below component:

Start Your Free Excel Course

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

  • The title (Describes the column)
  • The X-axis(For which the data are to be charted)
  • Y-axis (Intervals lowest and highest value)
  • Bars (Sum of the values)
  • Legend (Category of the dataset)

Data in a stacked area chart is plotted on the x-axis and y-axis; data values are plotted using data points that are connected using line segments. The area between the line segments and the axes is highlighted by filling it with color to showcase this magnitude. Area charts are primarily used when the magnitude of the trend is to be communicated (rather than individual data values).

How to Make Excel Stacked Area Chart?

Excel Stacked Area Chart is very simple and easy to use. Let us now see how to make Excel Stacked Area Chart with the help of some examples.

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

Example #1

Steps to make a stacked area chart in Excel:

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,452 ratings)
  • Select the entire dataset.

Stacked Area Chart (Select the entire dataset)

  • Click the Insert tab.

Stacked Area Chart Insert tab

  • In the Chart group, click on the Area Chart icon. Click on Stacked Area under the 2-D Area icon.

Stacked Area Chart Stacked Area under 2-D

  • This will give you an area chart, as shown below.

Stacked Area Chart area chart

  • Right-click on Legend and select Format Legend.

Stacked Area Chart select Format Legend

  • Go to Legend Options and select Bottom.

select Bottom

  • After that, our Chart looks like this.

Chart looks like this.

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

click on Layout

  • Our Final Chart looks like this.

Final Chart

In a quick glance at this chart, it is easy to summarize the following:

  1. Product 1: sales are less in comparison to the other quarter’s sales.
  2. Q2: sales slightly dip than the other quarter’s sales.
  3. Q3: sales show a slight dip from the Q1 sales, and Q3 sales show an increase from the Q2 and Q4 sales.
  4. Q3: for product 4, sales show significant growth over the other quarter’s sales.
  5. Q4: Product 5 sales show a slight increase for a product; the Q3 sales, sales show a comparatively higher increase.

Example #2

Steps to make a stacked area in Excel:

  • Select the entire dataset.

stacked area in Excel

  • Click the Insert tab.

 Insert tab

  • In the Chart group, click on the Area Chart icon. Click on the 3-D Area icon.

3-D Area icon

  • This will give you an area chart, as shown below.

an area chart

  • After adding the chart title and adjustment of legend as we have discussed in the previous example, our chart will look like this.

dding chart title

Note: We can change the graph background color from the Design section.

There is an option to create a chart in 2D and 3D variations. Try them out and choose the one that presents your data in the easiest and clearest style so that it will be easy to be understood data from the chart with putting less effort.

Information in an area chart is plotted on the x- and y-axis; data values are plotted using data points that are connected using line segments. Area charts are primarily used when the magnitude of the trend is to be communicated (rather than individual data values). The area between the line segments and the axes is highlighted by filling it with color to showcase this magnitude.

Before we talk about the strengths and limitations of an area chart, we’ll look at the variants of this chart; this will come in handy when we discuss the strengths and limitations.

The area chart can be visualized in two ways:

  • Data plots overlapping each other.
  • Data plots stacked on top of each other.

Where can we use Excel Stacked Area Chart?

  • Re-presentation can be read at a glance.
  • Stacked Area Graphs work best when we have multiple data series.
  • When we need to point out each data series from the total.
  • The entire graph represents the total of all the data plotted.
  • Can show part to whole changes over time.
  • Stacked Area Graphs also use the areas to convey whole numbers.
  • Useful for comparing multiple variables changing over an interval.
  • 100% shows how the constituent parts of a whole have changed over time.
  • Each area of color represents one part of the whole.
  • Best for comparing the sub-segments of results.

Limitation

  • A stacked are chart will not work for negative values.
  • It may be drawn to the upward and downward slopes of the colored area, but this can be misleading.
  • Difficult to add data labels since there is less white space available.
  • Area charts can imply more data than available.
  • The shapes of the middle series – those not attached to a bottom or top baseline – will be influenced by the values above and below, as well as their own.
  • In the case of deep drive Analysis, we cannot go for excel.
  • If there is huge data for different sets, then it will be very complex to understand the chart in a stacked area chart.

Things to Remember About Excel Stacked Area Chart

This is generally used in situations when we need to display some changes in time. Stacked charts help to compare the quantitative values each series brings to the whole category. The distinctive feature of an area chart is the filling done between the line segments and the x-axis to emphasize the magnitude. When rendered with stacked data plots, the area chart serves well for a part-to-whole analysis of each category. In the chart with overlapped data plots, the more the number of categories, the more the overlapping, and consequently, the lesser the visibility.

Recommended Articles

This has been a guide to Stacked Area Chart. Here we discuss How to make Excel Stacked Area Chart along with excel examples and a downloadable excel template. You may also look at these suggested articles –

  1. VBA Charts
  2. Excel Area Chart
  3. Marimekko Chart Excel
  4. Interactive 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
3 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 Stacked Area Chart Excel Template

EDUCBA

Download Stacked Area Chart Excel Template

EDUCBA

डाउनलोड Stacked 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