Standard Deviation Graph In Excel. I would add it at the end last column and give it a different color in the chart. A standard deviation graph in excel is a graph with error bars.
Right click in the chart area and choose select data. This calculates the standard deviation of the values in the range b1 to b10. In the popup menu.
The formula you ll type into the empty cell is stdev p where p stands for population.
Click the cell where you want to display the standard deviation of your data. Right click in the chart area and choose select data. If you don t have one yet start a new spreadsheet and input your data then create your desired chart before proceeding. If this is a chart problem you must define the stdev in the data if you want it charted.
