Tutorial Excel 2003 Pie Chart

Content
  1. Tutorial Excel 2003 Pie Chart
  2. Version differences
  3. Enter Pie Chart Data
  4. Select Pie Chart Data
  5. Mouse
  6. Using the keyboard
  7. Starting the Map Wizard
  8. Excel Chart Wizard Step 1:
  9. Excel Chart Wizard Step 2
  10. Excel Chart Wizard Step 3:
  11. Wizard Excel Chart Step 4
  12. Add color to a pie chart
  13. Change chart background color
  14. Change background color/remove border from legend
  15. Explode a piece of the pie

Tutorial Excel 2003 Pie Chart

This tutorial will walk you through the steps to create a pie chart in Excel 2003 using the Excel chart wizard.

If you follow the steps in the topics below, you will get 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. They differ from those in earlier versions of the program. Use the following links for tutorials on line charts for other versions of Excel.

Enter Pie Chart Data

See the sample image above for help with these instructions.

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

When entering data, keep the following rules in mind:

  1. Do not leave blank rows or columns when entering data.

  2. Enter your details in columns.

  • When you format the spreadsheet, list the names that describe 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 at a time in columns with a heading for each data series at the top.

For this lesson

  1. Enter the data as shown in the image above in cells A3 to B6.

Select Pie Chart Data

See the sample image above for help with these instructions.

Mouse

  1. Drag the selection with the mouse button to select the cells that contain the data to be included in the chart.

Using the keyboard

  1. Click in the top left corner of the chart data.

  2. Press and hold a key SHIFT on keyboard.

  3. Use the arrow keys on your keyboard to select the data you want to include in the pie chart.

Make sure to select the column and row headings you want to include in the chart.

For this lesson

  1. Select a block of cells from A3 to B6 using one of the methods above.

Starting the Map Wizard

See the sample image above for help with these instructions.

You have two options to start the Excel chart wizard.

  1. Click on icon graph wizard on the standard toolbar (see example image above)

  2. Press Insert > Chart… on the menu.

For this lesson

  1. Start the Chart Wizard using the method you prefer.

Excel Chart Wizard Step 1:

Select a chart from the default tab

See the sample image above for help with these instructions.

  1. Select a chart type in the left pane.

  2. Select a chart subtype in the right pane.

For this lesson

  1. Select chart type Cake on the left panel.

  2. Select a chart subtype Cake with visual 3D effect at the right.

  3. Click next.

Excel Chart Wizard Step 2

See the sample image above for help with these instructions.

  • After you select your data before starting the Excel Chart Wizard, you will see a preview of your chart in the top pane of the dialog box.

  • In your table, the data in the graph is surrounded by moving ants – an animated black box around your data.

  • Below the preview pane is a box with cell links to the range of data in the chart. If your chart doesn’t look right, make sure you select the correct range of data in the spreadsheet.

For this lesson

  1. Click next.

Excel Chart Wizard Step 3:

See the sample image above for help with these instructions.

While there are many options in the six tabs to change the look of your chart, we’re just adding titles in this step.

All parts of an Excel chart can be changed after you complete the Chart Wizard, so there is no need to set all formatting options now.

For this lesson

  1. Click on the tab titles at the top of the Chart Wizard dialog box.

  2. Enter a title in the chart title field: Biscuit shop sales income 2007 .

  3. Go to the tab Data Labels at the top of the Chart Wizard dialog box.

  4. In chapter Label contains Select option per cent to select it.

  5. If the chart looks correct in the preview window, click Next.

When you add a title and data labels, they must be added to the preview pane on the right.

Wizard Excel Chart Step 4

See the sample image above for help with these instructions.

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

  1. As a new sheet (places the chart on a different sheet from your workbook)

  2. As an object on sheet 1 (put the chart on the same sheet as your data in the workbook)

For this lesson

  1. Click the radio button to place the chart as an object on sheet 1.

  2. Click Done.

A simple pie chart is created and placed on your worksheet. The following pages describe how to format this chart to match the pie chart shown in Step 1 of this tutorial.

Add color to a pie chart

See the sample image above for help with these instructions.

Change chart background color

  1. Right-click once anywhere on the white background of the chart 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 tab patterns to select it.

  4. In chapter Square click on a colored square to select it.

  5. For this tutorial, choose purple in the lower-right corner of the dialog box.

  6. Click OK.

Change background color/remove border from legend

  1. Right-click once anywhere in the background of the chart legend to open the drop-down menu.

  2. Click with the mouse pointer on the first menu item: Legend Format to open the Format Legend dialog box.

  3. Click on the tab patterns to select it.

  4. In chapter The border on the left side of the dialog box, select an option Not to remove the border.

  5. In chapter Square click on a colored square to select it.

  6. For this tutorial, choose purple in the lower-right corner of the dialog box.

  7. Click OK.

Explode a piece of the pie

See the sample image above for help with these instructions.

To emphasize a particular part of the pie, you can move or “blow up” that piece from the rest of the map.

  1. Click the mouse pointer on the map to select it. Small dark cubes should be visible on the outside edge of the cake.

  2. Click a second time with the mouse pointer on the yellow (raisin) piece of cake. The dark blocks should now surround only this piece of the pie.

  3. Click and drag the mouse pointer to the left on the yellow piece of pie. The segment should move away from the rest of the chart.

  4. To return the broken slicer to its original position, repeat steps 1 and 2 above, then drag the slicer back to the pie chart. It will automatically return to its original location.

With the broken yellow segment, your chart should match the pie chart shown in Step 1 of this tutorial.

Leave a Reply

Your email address will not be published.