LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: How to add Upper/lower control limit lines to a graph (not drawn)

  1. To add upper and lower control limit lines to a graph in Excel 2003, you can follow these steps:
  2. Select the data range that you want to graph.
  3. Click on the Chart Wizard button on the toolbar or go to Insert Chart.
  4. Choose the chart type that you want to use and click Next.
  5. In the Data Range tab, make sure that the correct data range is selected and click Next.
  6. In the Chart Options tab, you can choose to add titles, labels, and other options to your chart. Click Next when you're done.
  7. In the Chart Location tab, choose whether you want to embed the chart in the current worksheet or create a new worksheet for the chart. Click Finish.
  8. Once the chart is created, right-click on the chart and choose Chart Options.
  9. In the Chart Options dialog box, click on the Lines tab.
  10. Under Lines, choose the type of line that you want to add (e.g. Upper Control Limit, Lower Control Limit).
  11. Enter the value for the line in the Value box.
  12. Choose the color and style for the line.
  13. Click OK to apply the changes.

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Upper and Lower limit lines on scatter graph Kcope8302 Excel Worksheet Functions 1 December 17th 08 02:55 PM
Cell Value Plus ( or Minus) Upper (or Lower) Limit Igorin Excel Worksheet Functions 6 November 20th 08 04:06 PM
create SPC chart with 3 sigma Upper/Lower control limit Daniel Charts and Charting in Excel 3 June 20th 07 10:31 PM
Upper/lower control limits? [email protected] New Users to Excel 1 May 25th 06 04:31 PM
Function for upper and lower control limits? CaptAndy Excel Worksheet Functions 1 March 29th 06 03:09 PM


All times are GMT +1. The time now is 05:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"