Pie Chart
 

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,

Pie Chart
 

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.

"Akhil Jain" wrote:

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,

Pie Chart
 

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

Sloth wrote:
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.

"Akhil Jain" wrote:

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,