Excel 2003 Pie Chart Tutorial

01
of 10

Excel 2003 Pie Chart Tutorial

Excel 2003 Pie Chart Tutorial
Excel 2003 Pie Chart Tutorial. © Ted French

This tutorial covers the steps to creating a pie chart in Excel 2003 using the Excel Chart Wizard.

Completing the steps in the topics below will produce a pie chart similar to the image above.

Version Differences

The steps in this tutorial use the formatting and layout options available in Excel 203. These differ from those found in early versions of the program. Use the following links for line graph tutorials for other versions of Excel.

02
of 10

Entering the Pie Chart Data

Excel 2003 Pie Chart Tutorial
Excel 2003 Pie Chart Tutorial. © Ted French

Note: For help with these instructions, see the image example above.

No matter what type of chart or graph you are creating, the first step in creating an Excel chart is always to enter the data into the worksheet.

When entering the data, keep these rules in mind:

  1. Don't leave blank rows or columns when entering your data.
  2. Enter your data in columns.
  • When laying out your spreadsheet, list the names describing the data in one column and, to the right of that, the data itself.
  • If there is more than one data series, list them one after the other in columns with the title for each data series at the top.

For this tutorial

  1. Enter the data as seen in the image above into cells A3 to B6.
03
of 10

Selecting the Pie Chart Data

Excel 2003 Pie Chart Tutorial
Excel 2003 Pie Chart Tutorial. © Ted French

Note: For help with these instructions, see the image example above.

Using the mouse

  1. Drag select with the mouse button to highlight the cells containing the data to be included in the graph.

Using the keyboard

  1. Click on the top left of the graph data.
  2. Hold down the SHIFT key on the keyboard.
  3. Use the arrow keys on the keyboard to select the data to be included in the pie chart.

Note: Be sure to select any column and row headings that you want to be included in the graph.

For this tutorial

  1. Highlight the block of cells from A3 to B6 using one of the above methods.
04
of 10

Starting the Chart Wizard

The Chart Wizard Icon on the Standard Toolbar
The Chart Wizard Icon on the Standard Toolbar. © Ted French

Note: For help with these instructions, see the image example above.

You have two choices for starting the Excel Chart Wizard.

  1. Click on the Chart Wizard icon on the standard toolbar (see image example above)
  2. Click on Insert > Chart... in the menus.

For this tutorial

  1. Start the Chart Wizard using the method you prefer.
05
of 10

The Excel Chart Wizard Step 1

Excel 2003 Pie Chart Tutorial
Excel 2003 Pie Chart Tutorial. © Ted French

Pick a Chart on the Standard Tab

Note: For help with these instructions, see the image example above.

  1. Pick a Chart type from the left panel.
  2. Pick a chart sub-type from the right panel.

For this tutorial

  1. Choose the Pie chart type in the left-hand pane.
  2. Choose the Pie with a 3-D visual effect chart sub-type in the right right-hand
  3. Click Next.
06
of 10

The Excel Chart Wizard Step 2

Excel 2003 Pie Chart Tutorial
Excel 2003 Pie Chart Tutorial. © Ted French

Preview your Chart

Note: For help with these instructions, see the image example above.

  • Having selected your data before starting the Excel Chart Wizard, you should see an example of your chart in the top window of the dialog box.
  • On your spreadsheet, the data that has been included in the chart is surrounded by the marching ants -- the animated black border around your data.
  • Below the preview window is a box containing the cell references of the data range included in the chart. If your chart doesn't look right, check to make sure you selected the right data range in the spreadsheet.

For this tutorial

  1. Click Next.
07
of 10

The Excel Chart Wizard Step 3

Excel 2003 Pie Chart Tutorial
Excel 2003 Pie Chart Tutorial. © Ted French

Chart Options

Note: For help with these instructions, see the image example above.

Although there are many options under the six tabs for modifying the appearance of your chart, in this step, we will only be adding the titles.

All parts of an Excel chart can be modified after you have completed the Chart Wizard, so it is not necessary to make all of your formatting options right now.

For this tutorial

  1. Click on the Titles tab at the top of the Chart Wizard dialog box.
  2. In the Chart title box, type the title: The Cookie Shop 2007 Sales Revenue.
  3. Click on the Data Labels tab at the top of the Chart Wizard dialog box.
  4. In the Label Contains section, click on the Percentage option to select it.
  5. When the chart in the preview window looks right, click Next.

Note: As you add the title and data labels they should be added to the preview window to the right.

08
of 10

The Excel Chart Wizard Step 4

Excel 2003 Pie Chart Tutorial
Excel 2003 Pie Chart Tutorial. © Ted French

Chart Location

Note: For help with these instructions, see the image example above.

There are only two choices for where you want to place your chart:

  1. As a new sheet (places the chart on a different worksheet from your workbook)
     
  2. As an object in sheet 1 (places the chart on the same sheet as your data in the workbook)

For this tutorial

  1. Click the radio button to place the chart as an object in sheet 1.
  2. Click Finish.

A basic pie chart is created and placed on your worksheet. The following pages cover formatting this chart to match the pie chart shown in Step 1 of this tutorial.

09
of 10

Adding Color to the Pie Chart

Excel 2003 Pie Chart Tutorial
Excel 2003 Pie Chart Tutorial. © Ted French

Note: For help with these instructions, see the image example above.

Change the background color of the chart

  1. Right click once with the mouse pointer anywhere on the white background of the graph to open the drop down menu.
  2. Click with the mouse pointer on the first option in the menu: Format Chart Area to open the Format Chart Area dialog box.
  3. Click on the Patterns tab to select it.
  4. In the Area section, click on a colored square to select it.
  5. For this tutorial, select the purple color at the bottom right of the dialog box.
  6. Click OK.

Change the background color/remove the border from the legend

  1. Right click once with the mouse pointer anywhere on the background of the graph's legend to open the drop down menu.
  2. Click with the mouse pointer on the first option in the menu: Format Legend to open the Format Legend dialog box.
  3. Click on the Patterns tab to select it.
  4. In the Border section on the left of the dialog box, click on the None option to remove the border.
  5. In the Area section, click on a colored square to select it.
  6. For this tutorial, select the purple color at the bottom right of the dialog box.
  7. Click OK.
10
of 10

Exploding a Piece of the Pie

Excel 2003 Pie Chart Tutorial
Excel 2003 Pie Chart Tutorial. © Ted French

Note: For help with these instructions, see the image example above.

To add emphasis to a particular piece of the pie you can move or "explode" this slice out from the rest of the chart.

  1. Click with the mouse pointer on ​the chart to highlight it. Small dark blocks should be visible on the outside edge of the pie.
  2. Click a second time with the mouse pointer on the yellow (oatmeal raisin) slice of the pie. The dark blocks should now surround just this single slice of pie.
  3. Click and drag to the left with the mouse pointer on the yellow slice of the pie. The slice should move away from the rest of the chart.
  4. To move the exploded slice back to its original location repeat steps 1 and 2 above and then drag the slice back to the pie. It will automatically return to its original location.

With the yellow slice exploded your chart should match the pie chart shown in Step 1 of this tutorial.

Format
mla apa chicago
Your Citation
French, Ted. "Excel 2003 Pie Chart Tutorial." ThoughtCo, Jun. 2, 2017, thoughtco.com/excel-2003-pie-chart-tutorial-3123558. French, Ted. (2017, June 2). Excel 2003 Pie Chart Tutorial. Retrieved from https://www.thoughtco.com/excel-2003-pie-chart-tutorial-3123558 French, Ted. "Excel 2003 Pie Chart Tutorial." ThoughtCo. https://www.thoughtco.com/excel-2003-pie-chart-tutorial-3123558 (accessed January 16, 2018).