Excel 2003 Pie Chart Tutorial

Pie chart in Excel 2003

Ted French / Lifewire

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.

The steps in this tutorial use the formatting and layout options available in Excel 2003. These differ from those found in early versions of the program. To tell what version you are running, consult our guide Simple Steps to See Which Version of Microsoft Office You Have.

01
of 09

Entering the Pie Chart Data

Setting the data for the chart

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:

  • Don't leave blank rows or columns when entering your data.
  • 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.

Next, enter the data as seen in the image above into cells A3 to B6.

02
of 09

Selecting the Pie Chart Data

Selecting the data to be used in the pie chart

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.

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

03
of 09

Starting the Chart Wizard

The Chart Wizard Icon on the Standard Toolbar

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.
04
of 09

The Excel Chart Wizard

The pie chart wizard in Excel
  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.
05
of 09

Previewing Your Chart

Excel 2003 pie chart preview
  1. 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.
  2. 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.
  3. 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.
06
of 09

Customizing Your Chart

Adding information to the legend

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.

  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.

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

07
of 09

Choosing Where Your Chart Should Go

Specifying the chart location

There are only two choices for where you want to place your chart: as a new sheet (places the chart on a different worksheet from your workbook) or as an object in sheet 1 (places the chart on the same sheet as your data in the workbook).

  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.

08
of 09

Adding Color to the Pie Chart

Excel 2003 Pie Chart Tutorial
Excel 2003 Pie Chart Tutorial.

Ted French, Lifewire, 2018

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.
09
of 09

Exploding a Piece of the Pie

The resulting pie chart in Excel 2003

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 at the beginning of this tutorial.