Thursday, July 18, 2013

How to Make a Pie Chart on Microsoft Excel 2003


1. Open MS Excel 2003. Click on the 'File' menu at the top of the screen and select 'Open.' Browse through the folders on your computer to locate the file with the data. Click on the file to select it and click on the 'Open' button to open the file.
2. Click on the Chart button which is in a tool bar at the top of the screen. This button looks like a bar graph and will open the Chart Wizard dialog box. You can also click on the 'Insert' menu and then select 'Chart' to open the wizard as well.
3. Click on 'Pie' from the list of chart types in the first step of the 'Chart Wizard' box. Select the type of pie chart you want for your report. Click 'Next' for the 'Chart Source Data' box.
4. Click back into your spreadsheet and highlight the data you want to graph. This array will populate in the 'Chart Source Data' box. Click 'Next' to open the 'Chart Options' Box.
5. Click through the tabs at the top of the 'Chart Options' box to select options you want to display with your chart. This includes a chart title, legend, and labels. When finished, click 'Next' to open the 'Chart Location' box.
6. Select 'As Object In' if you want to place the chart in your current work sheet. Select which worksheet in the workbook you want the chart to display in. Click 'Finish' to display the chart.

Blogger news