Table of Contents
To add an average line to a chart in Google Sheets, follow these steps:
1. Select the chart in which you want to add the average line.
2. Click on the “Customize” tab in the chart editor.
3. Under the “Series” option, click on the drop-down menu next to the data series you want to plot the average for.
4. Choose “Add average line” from the menu.
5. A horizontal line representing the average value for that data series will appear on the chart.
6. You can customize the appearance of the average line by clicking on it and adjusting the options in the “Series” tab.
7. To remove the average line, simply click on it and press the “Delete” key on your keyboard.
By following these steps, you can easily add an average line to your chart in Google Sheets, providing a visual representation of the overall trend in your data.
Add Average Line to Chart in Google Sheets
This tutorial provides a step-by-step example of how to create the following chart with an average line in Google Sheets:
Step 1: Enter the Data
First, let’s enter the following data that shows the total sales for some company during 10 consecutive weeks:
Step 2: Calculate the Average
Next, we can type the following formula into cell C2:
=AVERAGE($B$2:$B$11)
We can then copy and paste this formula to every remaining cell in column C:
Column C now contains the average of the sales values during the 10 weeks.
Step 3: Create Chart with Average Line
Next, highlight the cells in the range A1:C11, then click the Insert tab, then click Chart.
In the Chart editor panel that appears on the right side of the screen, click the Setup tab, then click the dropdown arrow under Chart type and choose Combo chart.
The following chart will automatically be created:
Additional Resources
The following tutorials explain how to create other common visualizations in Google Sheets:
Cite this article
stats writer (2024). How can I add an average line to a chart in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-add-an-average-line-to-a-chart-in-google-sheets/
stats writer. "How can I add an average line to a chart in Google Sheets?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-add-an-average-line-to-a-chart-in-google-sheets/.
stats writer. "How can I add an average line to a chart in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-add-an-average-line-to-a-chart-in-google-sheets/.
stats writer (2024) 'How can I add an average line to a chart in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-add-an-average-line-to-a-chart-in-google-sheets/.
[1] stats writer, "How can I add an average line to a chart in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I add an average line to a chart in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.