- To add upper and lower control limit lines to a graph in Excel 2003, you can follow these steps:
- Select the data range that you want to graph.
- Click on the Chart Wizard button on the toolbar or go to Insert Chart.
- Choose the chart type that you want to use and click Next.
- In the Data Range tab, make sure that the correct data range is selected and click Next.
- In the Chart Options tab, you can choose to add titles, labels, and other options to your chart. Click Next when you're done.
- 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.
- Once the chart is created, right-click on the chart and choose Chart Options.
- In the Chart Options dialog box, click on the Lines tab.
- Under Lines, choose the type of line that you want to add (e.g. Upper Control Limit, Lower Control Limit).
- Enter the value for the line in the Value box.
- Choose the color and style for the line.
- 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.