Excel Add Stdev Graph. Chart and then Marked Line. How to add error bars in Excel.
Click and drag your mouse across all of the cells with your averages to highlight them. Click on the Chart Elements button check the Error Bars checkbox and then choose More Options. This video demonstrates how to add error bars depicting standard deviation to a line plot in Excel 2010.
At the top of the dialog box you can see the built-in styles click on the third style Scatter with Smooth Lines.
Click the Chart Elements Button to open the fly-out list of checkboxes. Tap on the arrow next to Error Bars and pick the desired option. Add Chart Element. Apply a multiple of the standard deviation using the following formula.
