How to Overlay Two Line Graphs in Excel

Comparing two different sets of data over the same time period is one of the most common tasks in data analysis. Overlaying two line graphs is a perfect way to visually spot trends, patterns, and relationships between them. This guide will walk you through exactly how to create a comparison line chart in Excel, including the crucial step of adding a second axis for when your data sets are on completely different scales.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Overlay Two Line Graphs?

Before jumping into the "how," let's quickly cover the "why." A single line graph is great for showing how one metric changes over time. But when you overlay a second line, you unlock a much deeper level of insight. You can directly compare performance and start asking more valuable questions:

• Marketing: How does our website traffic trend compare to our lead generation? Do spikes in traffic from a campaign lead to a corresponding increase in leads?
• Sales: Is there a relationship between the number of sales calls made each week and the revenue closed that same week?
• E-commerce: How does our ad spend on Facebook correlate with our daily sales revenue from Shopify?

This technique turns two separate pieces of information into a single, cohesive story, helping you identify correlations that might otherwise be missed. It transforms your data from a simple report into a powerful analytical tool.

First, Set Up Your Data Correctly

The success of any chart in Excel begins with well-structured data. For an overlaid line graph, the setup is straightforward but essential. You need at least three columns:

1. Column 1: Your time period (the X-axis). This could be days, weeks, months, or years. Keep it consistent.
2. Column 2: Your first data series (the first Y-axis).
3. Column 3: Your second data series (the second Y-axis).

The most important rule is that both data series must share the same time period column. This ensures you're making a direct, apples-to-apples comparison over time.

Here’s a sample data set we'll use for our example. We're looking at monthly website visitors and the number of blog articles published each month.

Month,Website Visitors,Articles Published Jan,12500,8 Feb,14200,10 Mar,18000,12 Apr,17500,8 May,21300,15 Jun,25000,14

Your data table in Excel should look clean and simple, with clear headers at the top of each column.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Create an Overlaid Line Graph (With a Similar Scale)

Let's start with the simplest scenario: when both of your data sets use a similar numerical scale. For example, comparing the number of "New Leads" vs. "Qualified Leads" per month. Because the numbers are in a similar range, you can plot them on the same axis without any issues.

The process is incredibly simple:

1. Select Your Data: Click and drag your cursor to highlight all the data you want to include in the chart, including the column headers.
2. Insert Chart: Navigate to the Insert tab in the Excel ribbon.
3. Choose Line Chart: In the Charts section, click the icon that looks like a line graph (it's officially called "Insert Line or Area Chart").
4. Pick Your Chart Type: From the dropdown menu, select the first option under the 2-D Line category, which is simply called "Line."

That's it! Excel will immediately generate a chart with two distinct lines, each representing one of your data columns. It will also automatically create a legend so you know which line is which.

A Quick Note on Formatting Your Chart

An unformatted chart is a missed opportunity. Spend 30 seconds making it readable:

• Add a Title: Click on "Chart Title" at the top and give it a descriptive name, like "Website Traffic vs. Blog Articles Published."
• Label Your Axes: Click the plus sign (+) next to your chart, check the box for "Axis Titles", and label your Y-axis (e.g., "Monthly Visitors") and your X-axis (e.g., "Month").

The Big Problem: Overlaying Data with Radically Different Scales

Now for the most common challenge. What if you want to compare "Website Visitors" (in the tens of thousands) with "Articles Published" (values under 20)?

If you follow the steps above, Excel will plot both on the same Y-axis. The result? The "Website Visitors" line will look great, soaring up and down the chart. The "Articles Published" line, however, will look like a flat line hovering a few pixels above the zero mark. The tiny fluctuations from 8 to 15 articles are completely invisible when plotted against a scale that goes up to 25,000.

This renders the comparison useless. The solution is to create a secondary axis - a second Y-axis on the right-hand side of the chart that is scaled specifically for your second data set.

Step-by-Step: Adding a Secondary Axis in Excel

Creating a dual-axis chart might sound complicated, but it only takes a few extra clicks. Let's walk through it using our example of visitors vs. published articles.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 1: Create the Initial Chart

First, create the chart exactly as we did before. Select your data, go to Insert > Line Chart > 2-D Line. You will immediately see the problem we described - the "Articles Published" line will appear completely flat across the bottom.

Step 2: Select the Data Series to Change

Identify the line that is being dwarfed by the scale. In our case, it's the "Articles Published" line. Right-click directly on that flat line in the chart. A context menu will appear.

Tip: Sometimes it can be tricky to click on a line that's sitting on the axis. If you're having trouble, you can also right-click the corresponding entry in the chart legend.

Step 3: Open the 'Format Data Series' Pane

From the right-click menu, select Format Data Series... at the bottom. This will open a new pane on the right-hand side of your Excel window with various formatting options.

Step 4: Plot the Series on the Secondary Axis

Look for the Series Options tab (it usually looks like a small bar chart icon). Within this tab, you'll see a section called Plot Series On. There will be two radio buttons: "Primary Axis" and "Secondary Axis."

Click the Secondary Axis radio button.

Instantly, two things will happen:

1. A new vertical axis will appear on the right side of your chart, with a scale appropriate for the "Articles Published" data (e.g., 0 to 20).
2. Your "Articles Published" line will immediately adjust to this new scale, revealing its own trends and fluctuations.

You now have a beautiful, easy-to-read dual-axis chart where both data series are clearly visible and can be compared effectively.

Best Practices for Clear Dual-Axis Charts

A dual-axis chart is a powerful tool, but it can also be misleading if not designed carefully. Keep these principles in mind to ensure your chart is clear and effective.

1. Always Label Both Vertical Axes

This is the most critical rule. If you don't label both the primary (left) and secondary (right) axes, your audience will have no idea what each line represents. Click the plus icon (+) next to the chart, check Axis Titles, and clearly label both the left Y-axis (e.g., "Total Website Visitors") and the right Y-axis (e.g., "Number of Articles Published"). Clarity is your #1 goal.

Graphed

Still Building Reports Manually?

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

Watch the Demo

2. Use Distinctive Colors and Labeling

Make it incredibly obvious which line belongs to which axis. Excel usually does a good job of selecting different colors, but you can go a step further.

• Match Colors: Make the color of the right axis labels match the color of the line graphed against it. This creates a strong visual connection.
• Consistent Labeling: Make sure your axis titles use the same terminology as your legend (e.g., if the legend says "Articles Published", so should the axis title).

3. Be Mindful of the Zero Baseline

Excel sometimes automatically adjusts the axis scale so the baseline doesn't start at zero. For some data, this is fine, but it can exaggerate changes. If you want to show the full context, you can right-click an axis, choose Format Axis, and manually set the 'Minimum' bound to 0.

4. Don't Compare Apples and Oranges

Just because you can plot two things on the same chart doesn't always mean you should. The best dual-axis charts show a logical relationship. Ad spend vs. revenue makes sense. Website visitors vs. the price of coffee probably doesn't. Make sure the comparison you're making tells a meaningful story.

Final Thoughts

Mastering how to overlay two line graphs in Excel, especially with a secondary axis, is a high-impact skill that elevates you from a simple data enterer to a data storyteller. It's an essential technique for anyone in marketing, sales, or business operations who needs to analyze performance, find correlations, and communicate insights clearly and effectively.

Of course, building these reports in Excel often starts with a painfully manual process of downloading CSVs, cleaning the data, and building charts from scratch every week or month. At Graphed, we created a tool that automates this entire workflow. By connecting your data sources like Google Analytics, Shopify, or your CRM directly to our platform, you can skip the spreadsheet drudgery. You just ask questions in plain English - like "create a line chart comparing traffic and sales for the last 90 days" - and get a live, interactive dashboard in seconds, not hours.