How do you plot standard deviation lines onto a graph using excel??
Since you write about plots, I assume you have one already (and know how to make the chart). In the chart, Right-click on the graph line (one of the points or anywhere on the line. A little drop-down box will appear. One of the choices is: Add Trendline. click on Add Trendline. A Trendline dialog box pops up with 6 choices. Choose “Linear” and hit OK The Options tab will allow you to do future forcasting, and display the equation and R-squared value for the line. If you were talking about error bars… Use the Chart Type: Stock. The Stock chart requires 3 series. You’ll need to get the linear regression from the method, above, printing out the equation, then calculate the difference between the linear line and the actual data series (the ‘error’ data), putting the error data into a separate column. Use the left column if the error is low, use the middle column for the data, use the right column if the error is high. Repeat the data value in the left column for positive errors (data, da
