Sunday, October 14, 2012

How to Make a Graph on Excel 2003


1. Open the spreadsheet you want to graph in Excel 2003. Select 'Insert' and 'Chart' from the toolbar. The chart wizard appears.
2. Select the type of chart you want to create in the 'Standard Types' tab. To see a sample of how the chart will look, click the 'Press and Hold to View Sample' button and click 'Next.'
3. Click the button on the right of the 'Data range' text box to select the area of your spreadsheet you want to graph. The 'Source Data - Data range' toolbar appears.
4. Drag your mouse over the area of your spreadsheet that will be graphed.
5. Click the button on the right of the 'Source Data - Data range' toolbar to return to the chart wizard. A sample of your chart appears in the dialog box.
6. Select 'Rows' or 'Columns' under 'Series in' and click 'Next.'
7. Select the tab containing the options you want to customize: 'Titles,' 'Axes,' 'Gridlines,' 'Legend,' 'Data Labels' or 'Data Table.' Click 'Next.'
8. Select 'As new sheet' to place the graph in a separate worksheet or 'As object in' to place it into the current worksheet. Click 'Finish.'
9. Select the graph on your worksheet if you chose 'As object' in the previous step and drag it where you want it to appear.

Blogger news