How To Put Two Sets Of Data On One Graph In Google Sheets

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

Step 1

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

Step 2

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

Here’s how:

Step 1

Select the entire range you just entered data in, including the headers, then open the Insert menu and choose Chart

Step 2

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

Step 3

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.