I have the following scatter plot in Google Sheets and I would like to add a line that averages all my points.
Can I do that and if yes, how?
Google Sheets – How to Add an Average Line to a Scatter Graph
google sheetsgoogle-sheets-chartsgoogle-sheets-charts-trendlines
Related Solutions
Using a cell_object instead of just a value worked for me
var data = google.visualization.arrayToDataTable([
[ {v: 36, f: 'Name1 - 36'}, 1],
[ {v: 22, f: 'Name2 - 22'}, 3],
[ {v: 21, f: 'Name3 - 21'}, 6],
[ {v: 4, f: 'Name4 - 4'}, 2],
[ {v: 8, f: 'Name5 - 8'}, 2]
]);
You can use the method suggested by pnuts without combining the two tables. Enter both ranges, separated by commas:
Note that the ranges have 3 columns. One of them should have Y data in the 2nd column of the range, the other in the 3rd column of the range. This way, when the ranges are combined vertically by the chart, they reproduce the situation in pnuts' answer. The chart:
Related Topic
- Google Sheets – Create a Scatter Plot with Labels and Axis Values
- Google-sheets – Google Sheets Scatter plot with multiple data sets and independent axis
- Google-sheets – Line chart with hourly-daily data
- Google Sheets – Fix Table Data Not Creating Accurate Graph
- Google-sheets – Stacking time series in Google Sheet Combo chart
- Format Horizontal Axis Labels on Google Sheets Scatter Plot
- Google-sheets – Looking for a “weighted average if” functions in Google Sheets
Best Answer
First, calculate the linear regression factors: y=ax+b with the following formula:
Then add another column next to the y-axis and name it calculated y-axis. Build the following formula to calc. the y-axis and copy that for all x-values.:
Next is a piece of cake. Add the calculated y-axis to the existing data range or add it seperately.
UPDATE: I've added the calculated mean value as well, in order to be absolutely sure to have answered your question properly, see plot:
See example file for more details: plot regression example