View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default How to add Upper/lower control limit lines to a graph (not drawn)

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.