How to add Upper/lower control limit lines to a graph (not drawn)

I have several quality charts that I do monthly. How can I get the the
upper, lower and center lines to appear at a specific data point (number) as
part of hte chart format. In other words, withiout having to use the Draw
Line tool each time? Excel 2003.

Fake it.

In other words, seutp some "dummy" series that are calculated, and plot them
on your chart. Format them to look however you like, and remove the original
chart gridlines. If you have a legend, single-click twice the legend entry
for your dummy series and press delete. If done correctly, the entry will not
appear in the legend, but will still be plotted.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Turbojet" wrote:

I have several quality charts that I do monthly. How can I get the the
upper, lower and center lines to appear at a specific data point (number) as
part of hte chart format. In other words, withiout having to use the Draw
Line tool each time? Excel 2003.

Here are some tutorials:

Add a Line to a Column or Line Chart
http://peltiertech.com/Excel/Charts/AddLine.html

Run Chart with Mean and Standard Deviation Lines
http://peltiertech.com/Excel/Charts/RunChtLines.html

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Turbojet wrote:
I have several quality charts that I do monthly. How can I get the the
upper, lower and center lines to appear at a specific data point (number) as
part of hte chart format. In other words, withiout having to use the Draw
Line tool each time? Excel 2003.