How to Plot 3 Sets of Data on One Graph in Excel

Comparing three different sets of data on a single graph in Excel is one of the best ways to spot trends, relationships, and outliers at a glance. Instead of flipping between separate charts, you can tell a more cohesive and powerful story by visualizing them together. This guide will walk you through exactly how to plot three data series on one graph, making your reports clearer and more insightful.

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

Why Put Multiple Datasets on One Graph?

Before diving into the steps, it helps to understand why this is such a useful skill. Combining data series on a single chart isn't just about saving space, it's about adding context and clarity to your analysis.

• Find Relationships: Does your marketing spend directly influence website sessions? Does an increase in one product’s sales correlate with a dip in another's? Plotting them together makes these connections immediately obvious.
• Compare Performance: See how three different sales reps, marketing campaigns, or product lines stack up against each other over the same period.
• Tell a Complete Story: A single chart showing revenue, expenses, and profit gives a much quicker and more comprehensive overview of business health than three separate charts would.

Once you get the hang of it, you'll find yourself creating these multi-series charts all the time to build more compelling and more efficient reports.

Step 1: Get Your Data Ready

The most important step happens before you even click the "Insert Chart" button. Excel needs your data to be organized in a simple, logical table format. A clean setup prevents errors and makes the whole process smoother.

Your goal is to structure your table with a shared category or time period in the first column (this will be your X-axis) and each of your three data sets in its own column to the right (these will be your Y-axis values).

For example, let's say you're a marketing manager wanting to compare Monthly Ad Spend, Website Sessions, and Sales Revenue attributed to that spend. Your data should look like this:

Key things to check:

• Clear Headers: Make sure each column has a clear, descriptive header. Excel will automatically use these for your chart legend.
• No Blank Rows/Columns: Ensure there are no empty rows or columns in the middle of your data set, as this can confuse Excel when you select your data.
• Consistent X-Axis: The first column (Month, Date, Product Name, etc.) must be the common denominator for all three data sets.

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 2: Create a Combo Chart for Different Data Types

In our example, Ad Spend and Sales Revenue are measured in dollars, but Website Sessions is a raw count of visitors. If we plot all three on the same axis, the "Sessions" number (in the thousands) will make the "Ad Spend" number (also in the thousands) look very similar in scale, but both could completely flatten the "Sales Revenue" if it were in the hundreds. This is the perfect scenario for a combo chart with a secondary axis.

A secondary axis gives you a second Y-axis on the right side of your chart, allowing you to plot data of different scales and types accurately on the same graph.

How to Make the Chart:

1. Select Your Data Range: Click and drag to highlight all the data, including the headers. Don't just click the columns, select the specific cells that contain your data. For our example, this would be from cell A1 to D5.
2. Go to Chart Selection: Navigate to the Insert tab on the ribbon. In the Charts section, click on Recommended Charts.
3. Choose the Combo Chart: A new window will pop up. Click on the All Charts tab at the top. Scroll down and select Combo from the list on the left side.
4. Customize Each Data Series: This is where the magic happens. Excel will now show you each of your three data series (Ad Spend, Website Sessions, Sales Revenue) and let you assign a chart type and an axis to each one.
5. Click OK: Excel will instantly generate your combo chart. You'll see your two dollar-based data series represented as columns measured against the primary vertical axis (left), and your Website Sessions represented as a line measured against the secondary vertical axis (right).

Step 3: Refine and Format Your Chart for Clarity

Your combo chart is created, but a raw chart can still be confusing. Taking a few minutes to format it properly can make the difference between a good chart and a great one that everyone can understand immediately.

Add Clear Titles and Axes

A chart without labels is just a picture. You need to give it context. Click on your chart, and a green plus (+) icon should appear on the top right.

• Chart Title: Check this option and give your chart a descriptive name, like "Monthly Marketing Performance: Spend vs. Traffic vs. Revenue."
• Axis Titles: Check this box as well. Label your primary vertical axis (the left one) as "Amount ($)", your secondary vertical axis (the right one) as "Number of Sessions," and your horizontal axis as "Month." This small step eliminates all guesswork for your audience.

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

Improve Your Legend

The legend is Excel’s key to your data. Make sure it's clearly visible. If you click on the legend itself, you can drag it to a different position (top, bottom, left) to see what works best for your layout.

Adjust Colors and Styles

Clarity is key. If the default colors for your series are too similar, you can easily change them. Right-click on one of the columns or the line, select "Format Data Series," and then head to the paint bucket icon (Fill & Line) to choose a new color. Use contrasting colors to make each series pop.

Alternative Chart Types for Three Datasets

A combo chart is fantastic for handling different data scales, but if your three data series are all measured in the same unit (e.g., all are dollar amounts or all are percentages), you have other great options.

Grouped Line Chart

If all your datasets show a trend over time, a simple grouped line chart is perfect. Just select your data, go to Insert > Charts > and choose the "Line" chart. Excel will plot all three series with the same Y-axis, creating an easy-to-read comparison of trends.

Good for: Tracking sales for three products over a year or page views for three different blog posts over a month.

Clustered Column Chart

If your X-axis consists of distinct categories (like product names, regions, or sales reps) rather than time, a clustered column chart is a great choice. It places bars for each category side-by-side, making direct comparisons effortless.

Good for: Comparing quarterly revenue across three different regions.

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

Stacked Area Chart

A stacked area chart is useful when you want to show how individual parts contribute to a whole over time. Each data series is stacked on top of the previous one, so the total height of the chart represents the sum of all three.

Good for: Visualizing how different sources of web traffic (e.g., Organic, Social, Paid) add up to your total site visits over time.

Final Thoughts

With the right technique, combining three separate data sets into a single, cohesive graph in Excel is an incredibly effective way to uncover insights, compare performance, and tell a complete story with your data. By choosing the right chart type - like the versatile combo chart - and taking a few extra moments to add clear labels and titles, you can transform a bland spreadsheet into a compelling, professional-quality report.

Manually creating reports like this can be time-consuming, especially when you have to do them every week or month. At Graphed , we’ve made this process instantaneous. We built our product so you can connect your data sources once and then just ask an AI analyst for what you need in plain English. For example, instead of all the clicking, you could simply type "Show me a chart comparing last quarter’s ad spend, website sessions, and new revenue," and get back a live, interactive visualization in seconds.