How to Make a Two Line Graph in Google Sheets

Comparing two different trends side-by-side unlocks insights that a single metric can't provide. A two-line graph is perfect for this, letting you visually track the relationship between two data sets over time. This tutorial will walk you through exactly how to prepare your data, create a two-line graph in Google Sheets, and customize it to tell a clear and compelling story.

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

When Should You Use a Two-Line Graph?

A two-line graph is your go-to visualization tool when you need to compare two related metrics against the same independent variable, which is most often time. The goal is to see how they move together, move in opposite directions, or if one influences the other.

Here are a few common scenarios where a two-line graph is incredibly useful:

• Revenue vs. Profit: Track if your profits are growing in line with your revenue or if rising costs are eating into your margins.
• Marketing Spend vs. Sales: See if your ad budget increases are directly leading to more sales, and spot points of diminishing returns.
• Website Traffic vs. Signups: Monitor whether an increase in website visitors is actually translating into more user registrations or leads.
• Performance of Two Products: Plot the sales figures for two different products over several months to see which is more popular or growing faster.
• Organic Traffic vs. Paid Traffic: Compare website sessions from Google searches against traffic from paid ad campaigns to understand the impact of your marketing channels.

Essentially, if you have a question that starts with "How does X compare to Y over time?", a two-line graph is likely the right way to answer it.

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

Before you can create a beautiful graph, you need to structure your data correctly. Google Sheets needs to understand what to plot on the horizontal (X) axis and what to plot as the two lines on the vertical (Y) axis. The best format is clean and simple.

Organize your data into three columns:

• Column A: Your X-axis data. This is typically your timeline, like dates, months, or quarters.
• Column B: The data for your first line. Make sure the header clearly labels this metric (e.g., "Organic Traffic").
• Column C: The data for your second line. Give this a clear header as well (e.g., "Paid Traffic").

Example Data Structure:

Here’s what your data should look like before you begin. Notice the clear headers and consistent formatting.

A Few Quick Tips for Data Prep:

• Be Consistent: Make sure your labels are consistent (e.g., use "Jan" or "January" for the whole column, but don't mix them).
• Format as Numbers: Ensure your metric columns are formatted as numbers, not plain text. You can do this by selecting the column, going to Format > Number, and choosing the appropriate style.
• Avoid Blank Rows: Make sure there are no completely empty rows in the middle of your data set, as this can confuse the chart editor.

Step 2: Create a Basic Two-Line Graph

Once your data is neatly organized, creating the chart takes just a few clicks. Google Sheets is quite intuitive here and will do most of the heavy lifting for you.

1. Select Your Data Range: Click and drag your mouse to highlight all the cells containing your data, including the three-column headers (e.g., A1:C7 in our example).
2. Insert Chart: Navigate to the top menu and click Insert > Chart.
3. Choose Your Chart Type: Google Sheets will automatically open a Chart editor pane on the right-hand side. It’s pretty good at guessing what you want and should default to a Line chart. If it doesn't, click the dropdown menu under Chart type and select Line chart.

And that's it! You should now see a basic two-line graph appear on your sheet. Google Sheets automatically uses your first column as the X-axis and the other two columns as your two data series (lines).

Step 3: Customize Your Graph for Maximum Clarity

A default chart gets the job done, but a well-customized chart communicates your insights effectively and looks far more professional. The Chart editor pane has two main tabs: Setup and Customize. We'll be spending our time in the Customize tab.

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

Add Clear Chart and Axis Titles

Your graph needs a title that tells the viewer exactly what they are looking at. The same goes for the axes.

1. In the Customize tab, click on Chart & axis titles.
2. Select Chart title from the dropdown and type in a descriptive title, like "Website Traffic Performance: Organic vs. Paid."
3. Change the dropdown to Vertical axis title and add a label like "Website Sessions" so people know what the numbers represent.

Adjust the Legend and Line Colors

Improving the colors and legend position makes the graph easier to interpret at a glance.

• Legend: Go to the Legend section. You can change its position to the Top, Bottom, or Right. Placing it at the top often leaves more horizontal space for your data.
• Lines: Go to the Series section. Here you can customize each line individually. Select your first series (e.g., "Organic Traffic") from the dropdown. You can change its color, line thickness, and line style (dashed, dotted). Choose contrasting colors that are easy to distinguish. Then, select your second series and customize it as well.

Modify the Gridlines to Reduce Clutter

Sometimes the default gridlines can make a chart feel 'busy'. You can adjust them for a cleaner look.

• Go to the Gridlines and ticks section.
• You can adjust the spacing or remove minor gridlines altogether to create a simpler-looking canvas that puts the focus back on your data lines.

Pro Tip: Use a Second Y-Axis for Different Scales

What if you're comparing two metrics with wildly different scales? For instance, maybe you’re comparing Ad Spend (hundreds of dollars) with Website Traffic (tens of thousands of visitors). Plotting them on the same axis would make the Ad Spend line look nearly flat and lose all its detail.

The solution is a second vertical axis. This lets you plot one line against a left-side Y-axis and the other line against a right-side Y-axis with a different scale.

1. In the Customize > Series section, pick the series you want to move to the second axis (e.g., Ad Spend).
2. Look for the Axis dropdown and change it from Left axis to Right axis.
3. A new axis will appear on the right side of your chart, scaled perfectly for that data series.
4. Remember to add a corresponding axis title under Chart & axis titles > Right vertical axis title to avoid confusion!

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

Common Problems and How to Fix Them

Sometimes things don't go as planned. Here are some quick fixes for common issues you might run into.

• My chart shows one line as a flat line at the bottom. This almost always happens when your two metrics have very different scales. One data set is in the thousands while the other is only in the dozens. Use the 'Second Y-Axis' tip described above to fix it instantly.
• The dates on my X-axis are all bunched together and unreadable. This happens when you have many data points. You can fix this by either widening your chart or by going into Customize > Horizontal axis and checking the Slant labels option to tilt the text.
• The chart is blank or using the wrong data for the lines. Go back to the Setup tab of the Chart editor. Carefully check the Data range, X-axis, and Series boxes. Make sure the ranges are correct and that Google Sheets hasn't accidentally tried to plot your date column as a line.

Final Thoughts

Creating a two-line graph in Google Sheets is a powerful way to compare two trends and uncover meaningful relationships in your data. By structuring your data properly and using the customization options, you can move beyond default charts and build professional, easy-to-understand visualizations that tell a clear story.

Getting your data into Google Sheets often means manually pulling CSVs from different marketing and sales platforms, which can be tedious and time-consuming. We built Graphed to remove this friction entirely. It connects directly to your data sources like Google Analytics, Shopify, and social media ad platforms. Instead of wrangling spreadsheets, you can simply ask a question like, "create a line chart comparing my Shopify revenue with my Google Ads spend this quarter," and get an interactive, real-time dashboard in seconds.