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?
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?
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 )