Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
|
|||
|
|||
Answer: How to add Upper/lower control limit lines to a graph (not drawn)
Repeat steps 9-12 for each line that you want to add to the chart. Once you have added the lines, you can save the chart as a template so that you can reuse it each month with the same lines already in place. To do this, right-click on the chart and choose Save as Template. Give the template a name and click Save. To use the template in the future, go to File New Templates and choose the template that you saved.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Upper and Lower limit lines on scatter graph | Excel Worksheet Functions | |||
Cell Value Plus ( or Minus) Upper (or Lower) Limit | Excel Worksheet Functions | |||
create SPC chart with 3 sigma Upper/Lower control limit | Charts and Charting in Excel | |||
Upper/lower control limits? | New Users to Excel | |||
Function for upper and lower control limits? | Excel Worksheet Functions |