Pie Chart

[Akhil Jain]

I have the following data

Steve 30
Mike 20
Steve 40
Helen 10

I would like to create a pie chart such that


Steve 70 (Total of all Steve)
Mike 20 (Total of all Mike)
Helen 10 (Total of all Helen)

How can I do it in MS Excel


Thanks,

 

[Guest]

I think you would have to use a pivot table to combine the like entries, and
then use the pivot table as the data for the pie chart.

 

[loyosewe]

Can you please explain in detail on how to use pivot table..?