Рет қаралды 153,272
Google sheets has a new graphing interface. Many people have been frustrated by the limited options for adding error bars on scatter plots. Here I show a workaround that will allow you to put error bars with a different magnitude on each data point on your graph.
Update: To add a trendline to the same graph, go back to Data section of the chart editor, and select "add series" then select your mean values in a column, including the header 'mean' ie in my video, I'd select G1:G6 as series 6. It will just overlay another set of dots on top of your existing ones. Then Customize, Series, click the Apply To: dropdown menu and select the series that you just added, and you should be able to add a trendline to that series