How to Make a Stacked Bar Chart in Excel with AI

A stacked bar chart is one of the most effective ways to show how different parts contribute to a whole across multiple categories. But creating one in Excel can feel like you’re clicking through a maze of menus, especially when your data isn’t perfectly formatted. This guide will walk you through the traditional way to build a stacked bar chart in Excel and then show you a much faster, easier approach using AI.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What is a Stacked Bar Chart (And When Should You Use One)?

Before jumping into the "how," let's quickly cover the "what" and "why." A standard bar chart compares values across categories. A stacked bar chart takes it a step further: each bar represents a total, and the segments within that bar show the relative contribution of different sub-categories to that total.

Think of it like a set of building blocks. Each stack of blocks (a bar) represents a total, and the individual colored blocks (the segments) show you exactly what that total is made of.

This type of chart is incredibly useful when you want to answer questions like:

• Sales Performance: “What are our total sales per region each quarter, and which product line is contributing the most in each region?”
• Marketing Channels: “How many new leads did we generate each month, and what was the breakdown by channel (e.g., Organic, Paid, Social)?”
• Budget Tracking: “What’s our total department spend per month, broken down by category (e.g., Salaries, Software, Advertising)?”

Use a stacked bar chart when you need to understand both the overall total and its composition. If you only care about comparing the totals, a standard bar chart works fine. If you only care about the composition (the percentage of each part), a pie chart might be better, but only for a single category.

The Traditional Way: Making a Stacked Bar Chart in Excel Manually

Let's build a stacked bar chart the classic way. This process is straightforward if your data is clean, but it can be time-consuming if you need to create multiple charts or make frequent updates.

For our example, let's say we're an online store wanting to compare quarterly sales revenue from three different product categories: Apparel, Accessories, and Footwear.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 1: Get Your Data Ready

The most important step is setting up your data correctly in a table. Arrange your main categories in the first column and your sub-categories in the subsequent column headers. Your values should fill the cells in between.

Your table should look something like this:

Step 2: Select Your Data

Click and drag your cursor to highlight the entire data range you want to visualize, including the column and row headers (in our example, that's cell A1 through D5). Including the headers helps Excel automatically create the chart legend and axis labels, saving you a bit of work.

Step 3: Insert the Stacked Bar Chart

With your data selected, follow these clicks:

1. Navigate to the Insert tab on the Excel ribbon.
2. In the Charts group, click on the icon that looks like a bar chart (it's officially called "Insert Column or Bar Chart").
3. A dropdown menu will appear. Hover over the 2-D Bar options.
4. You’ll see a few choices. Select the second one, which is the Stacked Bar chart.

Excel will instantly generate a chart and place it on your worksheet. The 'Quarters' will be on the Y-axis, the sales values on the X-axis, and the bars will be segmented by Apparel, Accessories, and Footwear.

Step 4: Customize Your Chart for Clarity

The default chart is functional, but a few tweaks can make it much easier to read. When you click on your chart, two new tabs will appear on the ribbon: Chart Design and Format.

Here are a few quick improvements:

• Give it a title: Click on "Chart Title" and type in something descriptive, like "Quarterly Sales by Product Category."
• Add Axis Titles: Under the Chart Design tab, click Add Chart Element > Axis Titles. Add a title for the horizontal axis (e.g., "Total Revenue") to give your numbers context.
• Adjust Colors: Don't like the default blue and orange? In the Chart Design tab, you can use the Change Colors button for quick pre-made palettes, or right-click individual segments to change their fill color manually.
• Add Data Labels: Go to Add Chart Element > Data Labels > Center. This will place the value of each segment directly on the chart, which can make it easier to read than referencing the axis.

The Problem with the Manual Method

The manual process works, but it has its frustrations. Many marketers, founders, and sales managers just don't have the time to live inside spreadsheets. Common pain points include:

• It's slow: If you're building a weekly sales report, these steps add up. Wrangling data, inserting the chart, and customizing it can easily eat up precious time you could be spending on analysis.
• It's rigid: Want to see the data differently? Maybe a stacked column instead? Or filter out one of the product lines? You have to go back, modify your data range, or start over. There's not much room for quick, on-the-fly exploration.
• It's not intuitive: For those who aren't in Excel daily, remembering the right sequence of clicks is a pain. Forgetting to select headers, picking the wrong chart type, or getting lost in the customization menus is common.
• It doesn't scale: This process describes making one chart from one cohesive dataset. But what happens when you need to pull data from Google Analytics and compare it to sales data from Shopify? This simple workflow quickly breaks down into a nightmare of exporting different CSV files and trying to stitch them together manually.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

The Faster Way: Creating Excel Charts with AI

Today, there’s a much more efficient way to build charts without clicking through menus. AI-driven data analysis tools fundamentally change the workflow from manually building a visualization to simply describing the outcome you want to see.

Instead of acting like a graphic designer meticulously placing each element, you act like a manager giving clear instructions. You connect your data, and then you use plain English to tell the AI what chart to build. This approach eliminates the steep learning curve of traditional BI or spreadsheet software.

How to Create a Stacked Bar Chart with AI (A Conversation)

While Excel’s built-in features are slowly incorporating AI, dedicated conversational analytics tools have perfected this workflow. Here’s how the process generally works.

Step 1: Connect Your Data

Instead of manually preparing a spreadsheet, modern tools connect directly to your data sources. You might upload a raw CSV or Excel file, or better yet, connect directly to services like Google Sheets, Google Analytics, Shopify, QuickBooks, or your CRM. This creates a live link, so your data is always up-to-date without needing new exports every week.

Step 2: Ask Your Question in Plain English

This is where the magic happens. Once your data is connected, you just type a request into a chat interface. Let’s recreate our Excel chart from before.

You would simply type:

"Create a stacked bar chart of total sales per quarter, broken down by product category."

The AI understands the request, analyzes the structure of your data, identifies the 'Quarter,' 'Sales,' and 'Category' fields, and generates the fully customized stacked bar chart in seconds.

Step 3: Refine and Dig Deeper with Follow-up Questions

This is where AI really pulls away from the manual method. You can have a conversation with your data. The initial chart isn't the end of the analysis, it's the beginning. You can follow up with more questions to guide the AI.

For example:

• Changing the format: "Okay, show this as a 100% stacked bar chart instead." The chart instantly reformats to show the percentage contribution of each segment rather than the raw values.
• Drilling down further: "Which region had the highest sales in Q4?" The AI could provide a direct text answer or generate a new chart focused on Q4 data.
• Customizing visuals: "Make the 'Apparel' segment dark blue and add data labels to every section." Style changes are handled conversationally instead of through menus.
• Filtering the data: "Remake the chart but exclude the 'Footwear' category."

This interactive process enables you to explore data and uncover insights much more naturally, in the same way you might brainstorm with a human data analyst.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Why the AI Approach Is a Game-Changer

Adopting an AI-first workflow for reporting and analysis isn't just about saving a few minutes. It transforms how you and your team engage with data.

1. Incredible Speed: Hours of downloading, cleaning, and visualizing data shrink down to seconds. Instead of a weekly reporting "chore," you get real-time answers whenever you need them.
2. Truly Accessible: You no longer need to be a "data person." Anyone on your team, from a junior marketer to the CEO, can connect data and ask questions. This puts the power of data-driven decision-making in everyone's hands, not just those with technical skills.
3. Fewer Errors: AI greatly reduces the risk of human error, like selecting the wrong cell range or misrepresenting data. Because the AI has a contextual understanding of your data sources, it can build accurate visualizations reliably.
4. Focus on What Matters: You're free from the manual mechanics of chart-building. This lets you spend your time on higher-value tasks: interpreting the data, spotting trends, and planning what to do next.

Rather than feeling like you're fighting with the software to get it to work, you're having a productive conversation that leads directly to the insight you need.

Final Thoughts

Knowing how to create charts like a stacked bar chart in Excel is a valuable skill. But for busy teams who need fast, reliable answers, the manual process can become a bottleneck. Modern tools leverage AI to turn requests in plain English into powerful, accurate, and compelling data visualizations in just seconds.

This conversational approach is precisely why we built Graphed. We saw how much time sales and marketing teams waste manually pulling reports from a dozen different platforms into messy spreadsheets just to answer basic performance questions. We created Graphed to be your AI data analyst. You can connect all your sources in one place - like Google Analytics, Salesforce, or Shopify - and ask for the exact chart or dashboard you need. Instead of wrestling with Excel's menus, you get real-time, shareable dashboards instantly, just by asking.