Wednesday, September 25, 2013

How to Make a Chart in Excel 2003


1. Open your workbook in Microsoft Excel 2003 and select the spreadsheet containing the data you want to chart.
2. Highlight the cells containing the data you want included in the chart.
3. Click 'Insert' in the top menu bar and select 'Chart' to launch the Chart Wizard tool. You can also click the 'Chart Wizard' button on the Standard toolbar.
4. Select the 'Standard Types' tab in the dialog box that opens.
5. Select a general chart type (such as 'Bar' or 'Pie') from the 'Chart type' menu and then select a specific style from the adjacent 'Chart sub-type' menu. You can view a live preview of the chart by clicking and holding on the 'Press and Hold to View Sample' button at the bottom-right corner of the dialog box. Click 'Next' after making your choices.
6. Confirm that you selected the correct data previously. If you did not, highlight the data you want included in the chart, or manually enter the cells you want to use in the 'Data ranges' field. In either case, click 'Next' to confirm your selection.
7. Adjust the appearance of the chart in the resulting 'Chart Options' window by selecting the corresponding tab (such as 'Titles' or 'Gridlines'). The available options will vary, depending on the type of chart selected. Click 'Next' after specifying your preferences.
8. Select the 'As object in' option, click the adjacent drop-down menu and then select the name of the spreadsheet into which you want the chart inserted. To add the chart to a new spreadsheet, select the 'As new sheet' option and give the spreadsheet a name in the adjacent field.
9. Click 'Finish' to confirm your choices and generate the chart.

Blogger news