Create a pie chart of groups on the same graph

You can create a graph like the following example using data arranged in different layouts in the worksheet.

This pie chart shows the proportion of employees in each job classifcation, divided into male and female employees.

To create a pie chart of groups on the same graph, choose the layout option that matches your worksheet.

Option 1

Follow these steps if your worksheet contains a column of summarized data and two or more corresponding columns of categorical data.

Example worksheet

C1-T C2 C3-T
Job Classifications Counts Gender
R&D 20 Male
R&D 16 Female
Sales 11 Male
Sales 13 Female
Janitorial 12 Male
... ... ...
  1. Choose Graph > Pie Chart.
  2. Choose Chart values from a table.
  3. Under Categorical variable, enter a column of categorical data. In the example, Job Classifications is the categorical variable.
  4. Under Summary variables, enter a column of summarized data. In the example, Counts is the summary variable.
  5. Click Multiple Graphs, then click the By Variables tab.
  6. Under By variables with groups on the same graph, enter one more columns of categorical data. In the example, Gender is the categorical variable for groups on the same graph.
  7. Click OK in each dialog box.

Option 2

Follow these steps if your worksheet contains multiple columns of categorical data and each row is an observation. Minitab graphs the counts for each unique combination of categories.

Example worksheet

C1-T C2-T
Job Classifications Gender
R&D Male
R&D Female
Sales Male
... ..
  1. Choose Graph > Pie Chart.
  2. Choose Chart counts of unique values.
  3. Under Categorical variables, enter a column of categorical data. In the example, Job Classifications is the categorical variable.
  4. Click Multiple Graphs, then click the By Variables tab.
  5. Under By variables with groups on the same graph, enter a column of categorical data. In the example, Gender is the categorical variable for groups on the same graph.
  6. Click OK in each dialog box.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy