basic pie chart help

Hey,

I am trying to make a pie charge for 1 Colum that says yes or no and i want the pie charge to show for example if i had 10 cells 8 said yes and 2 said no i want the pie charge to show that.

I am using excel web version and struggling. Any ideas.

Thanks in advance.

Create a small table that counts the number of Yes/No values then build the pie chart from that.

See the yellow cells in the attached.

BSB

Great help

Thank you so much for that. i am useless at excel 20 years I.T Support and never managed to play with excel properly

Happy to help and thanks for the rep

Excel is only easy when you know how!

BSB