Create a pie chart of summarized data

In the Pie Chart dialog box, complete the following steps to specify the data for your graph. If your data are arranged differently than described below, go to Choose a pie chart.

  1. In Category names, enter the column of categorical data that defines the groups.
  2. In Summary values, enter the column of summary data that you want to graph.

In the following worksheet, Counts is the summary variable and contains the number of employees in a job classification. Job Classifications contains the category names. The graph shows the count of employees for each job classification.

C1 C2
Job Classifications Counts
R&D 36
Sales 24
Janitorial 12
Marketing 25
Manufacturing 48
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy