How to Make a Two Line Graph in Excel

Comparing two sets of data over time is one of the most effective ways to spot trends, measure progress, and make smarter decisions. A two-line graph is the perfect tool for the job, allowing you to visually stack one period or category against another. This guide will walk you through setting up your data, creating the chart, and customizing it to look polished and professional, all within Microsoft Excel.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Why a Two-Line Graph is So Powerful

Before jumping into the steps, it helps to understand why this type of chart is so useful. A two-line graph, also known as a multiple line chart, is designed to show how two or more variables change over the same period. This makes it incredibly easy to see relationships and comparisons at a glance.

Here are a few common scenarios where a two-line graph shines:

• Sales Performance: Comparing this year's monthly sales to last year's.
• Marketing Campaigns: Tracking conversion rates for two different ad campaigns running simultaneously.
• Website Analytics: Plotting traffic from Google against traffic from social media to see which channel is growing faster.
• Financial Tracking: Visualizing revenue versus expenses over a fiscal quarter.

In each case, the chart tells a story that a table of numbers alone can't. You can immediately see if one line is consistently outperforming the other, if trends are diverging or converging, or if there are specific moments where performance spiked or dropped for one or both variables.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step 1: Get Your Data Ready

The single most important step in creating an accurate and readable graph is formatting your data correctly. Excel is powerful, but it needs an organized table to understand what you want to plot. If your chart looks wrong, the problem usually starts here.

For a two-line graph, you need a simple three-column layout:

• Column A: Your X-axis labels. This is usually a time period like Day, Week, Month, or Quarter.
• Column B: The data for your first line (your first series).
• Column C: The data for your second line (your second series).

Let's use a common example: comparing monthly website traffic from two different sources - Organic Search and Paid Social - for the first half of the year. Your data in Excel should look like this:

Key Data Formatting Tips:

• Keep it Clean: Make sure your numbers are formatted as numbers, not text. Avoid putting any non-numeric characters (like commas or notes) within the cells themselves, use Excel's number formatting for that.
• Clear Headers: Use a single, clear header for each column. This header text will automatically become the name of your data series in the chart's legend.
• No Empty Rows or Columns: Ensure your data table is a solid block without any blank rows or columns in the middle, as this can confuse Excel when you select the data.

Step 2: Create the Basic Two-Line Graph

Once your data is neatly organized, creating the chart takes just a few clicks. Follow these steps precisely.

1. Select Your Data: Click and drag your mouse to highlight the entire data table, including the headers in the first row (e.g., cell A1 through C7 in our example).
2. Go to the Insert Tab: Look at the top ribbon in Excel and click on the "Insert" tab.
3. Find the Charts Group: In the middle of the Insert ribbon, you'll see a section for Charts.
4. Choose a Line Chart: Click on the icon that looks like a small line graph (it's labeled "Insert Line or Area Chart"). A dropdown menu will appear with several options.

For the clearest comparison, select the "Line with Markers" chart. The markers are small dots highlighting the exact data point for each month, making the chart much easier to read. Once you click it, Excel will instantly generate a chart and place it on your worksheet.

Congratulations! You've just created a two-line graph. It will show the months along the bottom (X-axis), the number of sessions on the left side (Y-axis), and two colored lines representing Organic discovery traffic and Paid Social traffic.

Step 3: Customize Your Graph for Clarity and Impact

The default chart Excel creates is functional, but it's not presentation-ready. A few quick customizations will make it clearer, more professional, and more effective at communicating your message.

When you click on your new chart, you'll see a few new buttons appear to its right edge. One looks like a plus sign (+). This is the Chart Elements shortcut, and it's your go-to tool for most customizations.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Add and Edit Chart & Axis Titles

By default, your graph may already have a title, but it's probably just "Chart Title." Always change this to something descriptive.

• Modify the Chart Title: Simply click on the text that says "Chart Title" and type something more meaningful, like "Monthly Website Traffic: Organic vs. Paid Social".
• Add Axis Titles: Your axes need labels. Click your chart, click the plus sign (+) icon, and check the box for "Axis Titles." A "Primary Horizontal" title will appear below your X-axis, and a "Primary Vertical" title will appear next to your Y-axis. Click each one to edit them. Label the horizontal axis "Month" and the vertical axis "Website Sessions."

Adjust the Legend

The legend tells your audience what each line represents. Excel usually places it neatly, but you can move it. Click the plus sign (+), hover over "Legend," click the small arrow that appears, and choose a new position like "Top" or "Right" to see what looks best.

Fine-Tune the Lines and Markers

Maybe you want to match your brand colors or make one line stand out more. It's easy to change the appearance of each line individually.

• How to Change Colors: Right-click directly on one of the lines in your chart. In the menu that appears, select "Format Data Series." A panel will open on the right side of your screen.
• Fill & Line Options: In the panel, click the paint bucket icon. Under "Line," you can change the color, width, or even make it a dashed line. Under "Marker," you can change the marker's fill and border color, style (square, triangle, etc.), and size. Repeat this process for the second line.

Format the Axes for Readability

Sometimes Excel's default axis scale isn't perfect. For example, the Y-axis may start at zero, but all the data points are above 5,000, leaving a lot of wasted white space at the bottom of the chart. Let's fix that.

• Right-click on the Y-axis numbers (the vertical axis) and choose "Format Axis."
• In the panel that opens, look for "Axis Options." Under "Bounds," you can set your own Minimum and Maximum values. For our data, setting the Minimum to 5,000 will make the variations between the lines more pronounced and easier to see.
• You can also change the number formatting here to add a comma separator or represent the values as currency, depending on your data.

Common Problems and How to Fix Them

Even with careful steps, Excel can sometimes be finicky. Here are a couple of the most common issues and their solutions.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

"My dates or months are being plotted as a third line!"

This is a classic issue. It happens when Excel misunderstands your data and thinks your first column (the months or dates) is another data series it should plot instead of using it for the X-axis labels.

• The Fix: The easiest solution is to check your data selection. Make sure you only selected the cells containing your data and the single header row. If that doesn't work, right-click the chart, choose "Select Data," and manually check that your "Horizontal (Category) Axis Labels" are correctly referencing your date column (e.g., A2:A7) and that your "Legend Entries (Series)" are referencing only your data columns (e.g., B1:B7 and C1:C7).

"I need to add a third line to my existing graph."

You created your chart, but now you want to add a third data source, like traffic from "Email Marketing". No need to start over.

• The Fix: Add the new data column to your table in Excel. Then, right-click on the chart and choose "Select Data." In the dialog box that appears, click the "Add" button under "Legend Entries (Series)." For the "Series name," click on the cell containing your new header ("Email Marketing"). For the "Series values," delete what's there and then highlight the new data points in your worksheet. Click "OK," and the new line will appear on your graph.

Final Thoughts

Creating a polished two-line graph in Excel is a straightforward process once you know how to structure your data and use the charting tools. By moving beyond the default settings and thoughtfully customizing your titles, axes, and colors, you can turn a simple chart into a powerful tool for visual storytelling and a clearer path toward valuable business insights.

While Excel is great for these types of charts, managing multiple data sources from ad platforms and analytics tools to create weekly reports can quickly become tedious. This is where Graphed comes in to remove that manual process entirely - no more downloading CSVs or wrestling with pivot tables. We designed it so you just connect your sources, then describe the chart you want in plain conversational language, like "compare Facebook Ad spend vs Google Ad spend this quarter," and a real-time, interactive dashboard gets created in seconds. That automation frees you from the constant cycle of exporting and updating spreadsheets so you can spend your time acting on insights, not chasing them down.