ExcelBanter - standard deviation plotting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - standard deviation plotting (https://www.excelbanter.com/excel-discussion-misc-queries/195948-standard-deviation-plotting.html)

patiencescientist

standard deviation plotting

how do I plot multiple standard deviation on a control chart?
Frist I am to find standard deviation and plot it I guess the range is 3x
the standard deviaton (using Excel 2003)

Wigi

standard deviation plotting

You could use (Y) error bars and specify in which cells Excel can find them.

Rightclick the series and choose Format data series...

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music

"patiencescientist" wrote:

how do I plot multiple standard deviation on a control chart?
Frist I am to find standard deviation and plot it I guess the range is 3x
the standard deviaton (using Excel 2003)

All times are GMT +1. The time now is 03:43 PM.