In this article, you’re going to learn how to plot multiple data ranges on a single graph along with their equations of linear regression.

Table of Contents

**Background**

You can plot multiple data ranges on a single graph in Google Sheets. This can help you study the relationship between variables by looking at the graph, for all the ranges plotted. In this article, you will run through the process of plotting multiple data ranges.

- In this article, we will run through how you can plot multiple data ranges on a single chart using Google sheets.
- But before jumping in, you must put the dependent variable data on the Y-axis and the independent variable data on the X-axis.
- If you follow the steps as described in this article, this is what a sample output would look like :

**Step to Plot Multiple Data Ranges on a Single Chart**

**Step 1:- Prepare a new dataset**

- Select the data common to both data ranges.
- Paste the X-axis variable to create a new common column (i.e. Sales).
- Copy and Paste the Y-axis variable to different columns (i.e. Profits 1 and Profits 2).

**Step 2:- Select the dataset of interest**

- Select the dataset you want to perform linear regression on.
- Left-click on cell
**A11**and drag it down to**C25**along with the titles of the variable columns as shown below:

**Step 3:- Insert Chart to represent the regression**

- After selecting the cells, click on the
**Insert**tab from the navigation bar and select the**Chart**option to create a graphical representation of the linear regression.

**Step 4:- Create a scatter plot for both datasets**

- After clicking on the
**Chart**button, navigate to the**Chart type**drop-down menu. - Select
**Scatter**chart as the chart type and select the**Scatter plot**, as shown below :

**Step 5:- Customize the graph settings to visualize regression**

- To plot the trendline, select the
**Customize**tab and go to the**Series**tab for plotting trendline :

**Step 6: Plot trendline, equation of graph, and method used for regression analysis **

- After selecting the
**Series**tab, checkmark the**Trendline**option to see the**Trendline**of the points as seen in the graph below. - Navigate to the
**Label**drop-down menu and select the**Use Equation**option to display the equation of the graph, as displayed on the top. - Tick mark the
**Show R**^{2}^{2}value of the graph. The higher the R^{2}value, the higher is correctness to predict any value and fit to the model.

**References**