1. Create a frequency distribution for the variable you want to analyze using Pivot Table Wizard or =COUNTIF statements.
2. 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.]
3. Click on Chart Wizard.
4. In Step 2 under Chart type, select Pie (or Doughnut). Select a Chart sub-type. Click Next.
5. In Step 2, make sure the correct data range is selected. Make sure the Series in: Columns option is selected. Click Next.
6. In Step 3, click Titles if it is not selected. Click in the Chart Title Box. Type a name for the chart.
7. Click on the Legend box. If you wish, turn off Show Legend.
8. Click in the data labels box. Under data labels, click Show label and percent. Click Next.
9. In Step 4, select where to put your chart (New Sheet or the existing sheet). Click on Finish.
10. 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.
11. 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 Page