How to add average line in excel scatter plot

Before you can add an average line, you need to calculate the average of your data set. This might sound like math class, but Excel makes it super simple. Here’s how you can do it:

• Select an Empty Cell: Choose a cell where you want to display the average.
  How to display equation on chart in excel on mac

  This is usually just below your data set.

• Use the AVERAGE Function: Type and then select the range of cells you want to average. For example, if your sales data is in cells B2 to B13, type .
• Press Enter: Hit Enter, and Excel will display the average of your selected data.

And there you go!

You’ve got your average. This figure is crucial because it’s the value you’ll use to create your average line. It’s like having the recipe before you start cooking.

With the average calculated, it's time to add it to your chart.

How to show trend in excel cell

This step transforms your chart from a simple graph into a tool that offers deeper insights. Follow these steps to add the average line:

• Add a Data Series: Right-click on your chart and choose Select Data.

  In the dialog box, click Add to create a new data series.

• Define the Series: Name the serie
  how to show average line in excel chart
  how to show mean on excel graph