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

[Nerdio]

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

 

[Saba Sabaratnam]

Hi Nerdio,

Create a pivot table like this

Row Labels	Count of Yes / NO
No	2​
Yes	3​
Grand Total	5​

And create a pivot chart as shown below.



Kind regard


Saba