How to Create a Stacked Area Chart in Excel

A stacked area chart is one of the best ways to show how different parts contribute to a whole over a period of time. Instead of getting lost in a table of numbers, you can instantly see trends, spot major shifts, and understand the big picture. This guide will walk you through exactly how to create, customize, and interpret a stacked area chart in Microsoft Excel, turning your raw data into a clear and compelling story.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is a Stacked Area Chart, Anyway?

Think of a stacked area chart as a combination of a line chart and a pie chart that moves through time. Like a line chart, it uses a horizontal axis (usually for time) and a vertical axis (for a value). But instead of just showing one line, it shows multiple data series represented by colored areas stacked on top of one another.

Each colored area represents a specific category, and its height shows the value of that category at a certain point in time. The top line of the entire chart represents the total of all categories combined. This makes it incredibly useful for seeing two things at once:

• How the total value changes over time.
• How the composition, or percentage contribution, of each category changes over time.

For example, you could use a stacked area chart to visualize your website's traffic sources each month. You could see the total traffic growing while also noticing that organic search (one colored area) is making up an increasingly larger piece of that total compared to paid search (another colored area).

When Should You Use a Stacked Area Chart?

Stacked area charts excel at telling stories about composition over time. They are the perfect choice when you want to answer questions like:

• "How has our product sales mix (e.g., Product A, Product B, Product C) changed over the last four quarters?"
• "What is the breakdown of our marketing budget spend across different channels (e.g., Google Ads, Facebook Ads, Email) each month?"
• "How have regional contributions to our total revenue shifted year over year?"

The core idea is showing a part-to-whole relationship changing over a continuous timescale.

However, they aren't perfect for every situation. You should avoid using them if your primary goal is to precisely compare the performance of individual categories against each other. Why? Because only the bottom category has a flat, stable baseline (the x-axis). Every other category's baseline is the fluctuating top line of the category below it, making it difficult to judge its exact value by eye.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Preparing Your Data for an Excel Chart

Before you click a single button in Excel's 'Charts' menu, getting your data structure right is the most important step. A poorly organized table will lead to a confusing chart, no matter how much you try to format it later.

For a stacked area chart, you need your data organized in a grid with:

• Time periods (days, weeks, months, quarters, years) in the first column.
• Categories you want to compare in the next set of columns. Each column should represent one category.
• A clear header row that names your time period column and each category column.

Let’s say you are a digital marketing manager tracking website sessions by source. Your data should look like this:

This simple, clean format is exactly what Excel needs to understand your data and build the chart correctly.

Step 2: How to Create the Stacked Area Chart in Excel

With your data perfectly formatted, creating the chart itself takes just a few clicks. Follow these steps, and you'll have a visual in seconds.

1. Select Your Data Range

Click and drag your cursor to highlight the entire data table, including the header row and the first column with dates or time periods. In our example, you would select the cell with "Month" down to the last cell with "1,600". Including the headers allows Excel to automatically create a legend for your chart.

2. Insert the Chart

Navigate to the Insert tab on Excel's top ribbon. In the Charts section, look for the 'Insert Waterfall, Funnel, Stock, Surface, or Radar Chart' icon. It looks like a small waterfall chart. Click the small drop-down arrow next to it.

Oh wait, that's not it. Common mistake! An Area chart has its own icon. Look for one that looks like a line chart with the area underneath filled in. It’s called 'Insert Line or Area Chart.' Click on it.

A dropdown menu will appear showing various Line and Area chart options. Under the '2-D Area' section, you'll see three options. Hovering over each one will give you a preview.

• The first is a standard Area chart (where series can overlap and obscure each other).
• The second is the Stacked Area chart (what we want).
• The third is the 100% Stacked Area chart.

Click on Stacked Area.

Voila! Excel will instantly drop a basic stacked area chart onto your worksheet. It will show the months along the bottom (x-axis), the session counts on the side (y-axis), and the traffic sources stacked in colored layers.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 3: Customizing and Formatting Your Stacked Area Chart

Your basic chart is ready, but a little formatting can make it much easier to read and look far more professional. This is where you transform a simple Excel output into a powerful communication tool.

Add a Clear Chart Title and Axis Labels

The default title is probably just "Chart Title." Double-click on it and change it to something descriptive, like "Monthly Website Sessions by Source."

To add axis titles, click on your chart to select it. A '+' sign will appear in the top-right corner. Click it, then check the box for Axis Titles. You can then edit the horizontal and vertical axis titles to something like "Month" and "Total Sessions," respectively.

Adjust Colors and Styles

Don't like the default colors? With the chart selected, a Chart Design tab will appear in the ribbon. Here you can find various pre-set Chart Styles or use the Change Colors button to pick a different color palette that fits your branding.

For more control, right-click on a specific colored area in the chart and select 'Format Data Series.' A panel will open on the right where you can click the paint bucket icon to change the fill color or border for that specific category.

Refine Your Legend

The legend helps people understand what each color means. You can click on the legend and drag it to a different position (top, bottom, left, or right). For stacked area charts, placing the legend at the top or bottom usually works best to maximize the width of the chart area.

Format Your Axes

Right-click on the vertical axis (the numbers) and choose 'Format Axis.' Here you can change the number formatting (e.g., add commas to thousands), set an explicit minimum or maximum value, or change the interval for the gridlines to make the chart less cluttered.

Exploring Other Types of Excel Area Charts

Excel offers two other main variations of the area chart that are useful in different contexts.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

100% Stacked Area Chart

What if you care less about the absolute total and more about the proportion of each category over time? This is where the 100% Stacked Area Chart shines.

Instead of plotting the actual values, it plots the percentage contribution of each category, so the y-axis always runs from 0% to 100%. This is great for visualizing changes in market share or budget allocation. Using our example data, it would clearly show organic search growing from being ~44% of total traffic in January to ~49% in June, even while all other channels were also growing in absolute numbers.

3-D Stacked Area Chart

In the 'Charts' menu, you'll also see options for 3-D charts. While they can look visually interesting at first glance, data visualization experts generally advise against using them. The 3-D perspective can distort the data, making it very difficult to accurately estimate the size of the areas. For clear communication, stick with the 2-D versions.

Best Practices and Common Pitfalls

Keep these final tips in mind to make your stacked area charts as effective as possible:

• Keep Categories Limited: These charts work best with about 3 to 6 categories. Any more than that and the chart quickly becomes a rainbow-colored, unreadable mess.
• Order Your Data Strategically: For visual stability, place the largest or most consistent category at the bottom of the stack. This creates a smoother baseline for the categories above it.
• Beware of Occlusion: In some cases, a very large category can have peaks that completely hide a smaller category's data points for a specific period. Be mindful if you have categories with highly volatile data.
• Use for Trends, Not Exact Values: Remember, the main purpose is to show trends in the total and the composition. If you need people to make precise comparisons between individual categories (other than the bottom one), a simple line chart or clustered column chart is a better option.

Final Thoughts

Armed with these steps, you can confidently create and customize stacked area charts in Excel to tell a clearer story with your data. By structuring your data well, choosing the right chart type, and applying thoughtful formatting, you can highlight key trends in composition over time that might otherwise go unnoticed in a spreadsheet.

Of course, manually exporting data from platforms like Google Analytics, Shopify, or your CRM into Excel is a time-consuming first step. Every week, it's a cycle of downloading CSVs, cleaning them up, and rebuilding reports. This is where we built Graphed to help. We connect directly to all your data sources so you can skip the manual spreadsheet wrangling entirely and ask for reports in plain English. Just describe the dashboard you need - like "a stacked area chart of website traffic from Google Analytics by source for the last six months" - and it gets built for you in seconds, with live data that updates automatically.