Making a Pie Chart (Or a Doughnut Chart)
- Create a frequency distribution for the variable you want to analyze using Pivot Table
Wizard or =COUNTIF statements.
- Select (highlight) the value labels (coding category names) and frequencies (counts) you
have created. [In Excel 2000: Copy and paste the value labels and frequencies to a blank
space in the worksheet. Be sure the copied labels and frequencies are highlighted.]
- Click on Chart Wizard.
- In Step 2 under Chart type, select Pie (or Doughnut). Select a Chart sub-type. Click
- In Step 2, make sure the correct data range is selected. Make sure the Series in:
Columns option is selected. Click Next.
- In Step 3, click Titles if it is not selected. Click in the Chart Title Box. Type a name
for the chart.
- Click on the Legend box. If you wish, turn off Show Legend.
- Click in the data labels box. Under data labels, click Show label and percent. Click
- In Step 4, select where to put your chart (New Sheet or the existing sheet). Click on
- To edit the chart, if it is not activated, click inside the chart to activate it. The
handles will appear. Move the cursor to one of the handles until it changes to a double
arrow. Click and drag to enlarge the chart.
- To print the chart, make sure the chart is activated. In the file menu, select print. In
the print menu, be sure the selected chart button is activated. Click OK.
Return to the Statistics Home