control chart

[Guest]

Help, I know how to create a line chart, (run chart) but I want to show mean and standard deviation, can you help?

 

[Tushar Mehta]

Check:

On my site:
Excel | Tutorials | Color Zone in XY Charts
Excel | Tutorials | Shaded Bands

as well as Jon Peltier's site:
http://www.peltiertech.com/Excel/Charts/statscharts.html

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Guest]

Can you give me your web address before 10 pm est so that i can learn how to place std dev. ucl and lcl on a run chart in excel?

 

[Jon Peltier]

Well, it's a bit past your deadline, but here is a page that might help:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon

 

[S. Daum]

There is generally more to control charting than meets the eye.
See these sites for some background.
http://www.qualityadvisor.com
http://www.chartrunner.com

Can you give me your web address before 10 pm est so that i can learn how

to place std dev. ucl and lcl on a run chart in excel?