Create a Pivot chart (Pie Chart) based on value in one field to show proportions of each

Nerdio

New Member
Joined
Dec 5, 2011
Messages
10
This seems a really simple thing to do, but I don't seem to be able to do it.

I want to create a Pivot Chart that works off one column of data. the column of data simply holds "Yes" or "No". So I want a pie chart that shows the proportion of "Yes" and proportion of "No". What do I need to do to achieve this? (I may later need to make a more elaborate Pie chart which has multiple values, say 1, 2 and 3 and show the proportions of each.

Thanks
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Saba Sabaratnam

Board Regular
Joined
May 26, 2018
Messages
136
Hi Nerdio,

Create a pivot table like this
Row LabelsCount of Yes / NO
No
2​
Yes
3​
Grand Total
5​

And create a pivot chart as shown below.

1575780583479.png

Kind regard


Saba
 

Watch MrExcel Video

Forum statistics

Threads
1,119,182
Messages
5,576,569
Members
412,733
Latest member
korayuyanik
Top