Easy Tech TutsHow to Plot Two Data Sets in One Graph in Google Sheets Easily 2026
By Impran M N
Comparing two sets of numbers side by side is much easier with a single combined graph than with two separate charts. This guide walks through plotting two data sets in one graph in Google Sheets, a technique useful for comparing trends, tracking performance, or analyzing outcomes across different datasets.
01Prepare your data
Organize both data sets into clearly labeled columns so Sheets can plot them together without confusion.
02Create the first graph
Start by building a basic chart using your primary data set as the foundation for the comparison.
03Add the second data set
Bring in your second series so both sets of values appear on the same chart, making direct comparison possible.
04Finalize your graph
Adjust labels, colors, and axes so the combined chart is easy to read and clearly communicates the comparison you're making.
Frequently asked questions
Why would I want two data sets on one graph instead of two separate charts?
A single combined graph makes it much easier to visually compare trends, such as sales figures against marketing spend, side by side.
Do both data sets need to use the same scale?
Not necessarily. Google Sheets allows for a secondary axis when the two data sets have very different value ranges, keeping both readable.
Is this technique beginner-friendly?
Yes, the process is designed to be approachable even for those with little to no experience with data visualization in Google Sheets.
What are common business use cases for this?
Businesses often use this to compare sales figures against marketing expenditures or track performance across two related metrics over time.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
