Standard Deviation Graph In Excel. Select the data and go to the insert tab then under charts select scattered chart then select smoother scatter. I would add it at the end last column and give it a different color in the chart.
Type stdev b1 b10 without quotes. The bell curve or standard deviation graph is used to visualise the spread of data. A standard deviation is stated this way in a cell stdev c5 f43 this will return the standard deviation for a group of cells.
The standard deviation tells how much the data is clustered around the mean of the data.
In the popup menu. Select your chart by clicking on it once. Now we will have a chart like this. Click the cell where you want to display the standard deviation of your data.
