In this tutorial, you will learn how to put two sets of data on one graph in Google Sheets.
If you have two related data sets in Google Sheets, you may want to chart them on the same graph. This can be useful to compare and contrast the data sets and also saves space in your spreadsheet
While it may not be immediately obvious how to make such a grap, it’s quick and easy in Google Sheets. Just follow the steps below.
Prepping The Data
The first step is to make sure your data is formatted correctly for charting
Start with column headers for the X-axis and two data sets. These will be used for graph labels. In the image below, temperature is the X-axis, and the sales numbers for the two teams are the two data sets
Now add your data underneath the headers. If X values are the same for the two datasets, this step is straightforward. If you have different X values for the two data sets, you will have to enter all values for the first data set, followed by the values for the second dataset, separately.. Ie, start with all X and Y values for the first data set directly under the header, then include all X and Y values for the second dataset underneath that
Inserting the Graph
Once you have your data entered as described above, it’s time to graph it
Select the entire range you just entered data in, including the headers, then open the Insert menu and choose Chart
In the Chart Editor sidebar, under Chart Type, select the type of graph you want. For this example, we’ll use a smooth line chart to nicely demonstrate the difference between the two data sets
Your chart displaying both data sets is ready
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to put two sets of data on one graph in Google Sheets. Want more? Check out all the Google Sheets Tutorials.