# How to Add Average Line to Chart in Google Sheets(Quick & Easy Guide)

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

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.

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.