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

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Saba Sabaratnam

Board Regular
Joined
May 26, 2018
Messages
131
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,118,076
Messages
5,570,070
Members
412,310
Latest member
mark884
Top