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. |
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. |
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. |
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. |
All times are GMT +1. The time now is 10:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com