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,

[Sloth]

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,
>
>

[loyosewe]

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,
> >
> >