In this tutorial, you will learn How to add average line to chart in Google Sheets .
How to Add Average Line to Chart in Google Sheets : Step by Step Guide
Here are the steps to How to Add Average Line to Chart in Google Sheets
Step 1 : Prepare your dataset
Open Google Sheets and prepare your data.
In this example we will use the below dataset which shows the sales of a product from Jan to Dec.
Step 2 : Perform Average Calculation
Now use the below formula to calculate the average.
Click on the Cell C2 and type or copy the below formula on the fx function area :
=AVERAGE($B$2:$B$13)
After typing the formula press Enter .
Calculated average value
Navigate to the blue square icon on cell C2 and drag it downwards to apply the formula on rest of the cells on Column C.
Step 3 : Insert a Chart
Now Click on any of the cell in the data range and Press CTRL+A key to select the completed dataset.
Now Click on Insert->Chart
Google Sheets will automatically insert a Combo Chart with Average Line as shown below.
The blue bars on the combo chart indicate the sales made during each month and the red line indicate the average sales during Jan to Dec.
How to Add Average Line to Chart in Google Sheets(Conlcusion)
Using the above tutorial you can quickly add average line to chart in Google Sheets.
We hope this tutorial on How to Add Average Line to Chart in Google Sheets was useful.
How do I plot an average line in Google Sheets?
1.Prepare your dataset
2.Perform Average Calculation
3.Insert a Chart ,Go to Insert->Chart .
A Combo Chart will be inserted automatically by Google Sheets with an averahe line.
How do I add an average column in Google Sheets?
To add an average column in Google Sheets Choose the cells where you need to calculate the average and enter the AVERAGE function into the fx function area .Once you press enter you will get the calculated average values on the cell.
Related articles :
How to Insert Spin Button in Google Sheets ( Easy Guide )
How to Freeze Rows in Google Sheets
How to Calculate Square Root and Cube Root in Google Sheets(Quick & Easy Guide)
How to use SUMSQ Function in Google Sheets(Quick & Easy Guide )
