Unfortunately although standard deviation error bars can be added in 3.0 instead of the error bars centering on the mean they incorrectly center on each plot, but I have come up with a work around which is illustrated below
- SD1.png (7.76 KiB) Viewed 6155 times
Column C is the mean and in the above case this is hidden as it is plotted as an invisible line. At D2 I've calculated the SD using the formula =STDEV($B$2:$B$5) which I've simple copied down to D4.
I have then added the error bars to the plot of the mean using the following settings.
- SD2.png (8.11 KiB) Viewed 6157 times
Hopefully by the time 3.0 is in RC stage this glitch will have been sorted.