Standard Deviation Axis

[kendallgriffin]

i am trying to create a scatter diagram that will give me standard deviations as the axis. the other axis will be the date i entered the data
i would like it to look like this:
SD PIC.png

[MrShorty]

Do you have the standard deviations calculated in the spreadsheet? I don't think there's any way to get the chart to calculate standard deviation from the raw data. But, if you calculate the standard deviations in the spreadsheet, creating the chart should be as easy as plotting the standard deviation against the date.

[shg]

You could set the number format for the vertical axis to +0" SD";-0" SD";"MEAN" and the major unit to 1.