If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
How to add Upper/lower control limit lines to a graph (not drawn)
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. |
Thread Tools | |
Display Modes | |
|
|