How to Determine Y Axis Values in an Excel 2003 Line Graph

1. Highlight the entire range, including the x-axis and y-axis values.
2. Click 'Insert' from the menu bar. Click 'Chart.' This launches the Chart Wizard. Alternatively, click the icon of a bar graph from the toolbar.
3. Select 'Line' under 'chart type.' Pick a sub-type from the right pane. Click 'next.' The wizard will generate a preview of your chart, guessing which values you want on the y-axis. The window will change to 'Step 2 of 4.' If the wizard correctly determined your values, click 'finish' to insert the chart.
4. Click the 'series' tab. One box will contain the cell numbers of the range Excel identified. It will look something like '=Sheet1!$B$3:$B$8.'
5. Click the icon at the right end of this box. It will contain a small red arrow. The wizard will appear to close, and the spreadsheet will return.
6. Highlight the data you want to select as your y-axis values. The wizard window will return.
7. To select y-axis values for additional data series, repeat Steps 5 and 6 for other boxes in the window.
8. Click 'finish.'