How to Create a Standard Deviation Graph in Excel
You can use Microsoft Excel to create a chart that visually displays the standard deviation of a data set using error bars.
Standard deviation is a common statistical calculation used to determine how much the individual samples in a data set vary from the mean (or average) of the data. You can use Microsoft Excel to create a chart that visually displays the standard deviation of your data using error bars.
Enter all the samples from each data series into a separate row (if you have a single series of data, enter all your data into a single row).
Add a formula to calculate the average for the first row of data.
Add a formula to calculate the standard deviation for the first row of data.
Copy the mean and standard deviation cells for the first row of data into the cells next to all the other data rows.
Click on the Insert tab on the Office Ribbon, then click Line in the Charts section of the ribbon, then click the Line with Markers icon.
You will need to select the cells with the standard deviation calculations later, so move the chart to make sure it doesn't cover any of the cells in the standard deviation column.
Click on the empty white space in the chart to select the chart.
Click on the Format tab in the Chart Tools area of the Office Ribbon.
Click on the chart selection menu in the Current Selection section of the Office Ribbon and select Series1 from the menu.
Click the Layout tab in the Chart Tools area of the Office Ribbon.
Click the Error Bars icon in the Analysis section of the Office Ribbon.
Click More Error Bars Options... in the Error Bars menu.
Move the Format Error Bars dialog box so it doesn't cover any of the cells containing the standard deviation calculations.
Set the Direction in the Display section to Both.
Click Custom: in the Error Amount section.
Click the Specify Value button.
Click the range selection button on the Positive Error Value field.
Select all the cells in your worksheet containing standard deviation calculations.
Press the Enter key.
Repeat the range selection for the Negative Error Value field, again selecting all the cells in your worksheet containing standard deviation calculations.
Press the OK button to close the Custom Error Bars dialog box, then press the OK button to close the Format Error Bars dialog box.
Click outside the chart to deselect the chart series.