# How to Add an Average Line to an Excel Chart -3 Steps

### Step 1 – Prepare the Dataset

Assume you have the following class result table:

• Select the data range and go to Insert >> Recommended Charts.

### Step 2 – Select a Chart Type

• Go to Combo >> All Charts >> Clustered Column-Line >> Average Marks >> Line >> OK.

The Average Line is added to the chart:

### Step 3 – Apply a Custom Combination

• Select Custom Combination.
• Select the Marks >> Clustered Column >>Line.

The line graph with the average will be displayed.

## How to Add an Average Line in an Excel Pivot Chart

Steps:

• Create a Pivot Table and a chart based on the table: go to Insert >> Table >> Pivot Table >> From Table/Range.

• Select Existing Worksheet and click OK.

• In PivotTable Fields check Name and Marks.
• Choose Insert >> 2-D Column.

The Marks graph is displayed.

• In PivotTable Fields check Average Marks. A new column will be displayed in the chart.

• To see the Average Marks as a horizontal line: right-click >> Change Chart Type.

• Go to Combo >> Custom Combination >> Sum of Average Marks >> Line >> OK.

The average line is displayed in the marks charts.

## Related Articles

<< Go Back to Calculate Average in Excel | How to Calculate in Excel

Get FREE Advanced Excel Exercises with Solutions!
Al Ikram Amit

Al Ikram Amit, holding a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a key Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Amit not only skillfully addresses complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his steadfast commitment to consistently delivering exceptional, high-quality content that adds significant... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF