Thread: How do I create a Pie Chart from a LIST of Data?

I have a list of Data:

DATA
a
b
b
c
c

How do I create a chart from this data to show:
a 20%
b 40%
C 40%

Do I have to perform separate calculations, or is there a way this will just
work?
Thanks,
Jim

I'd suggest you use a pivot table to gather the summary data you need and go
from there.

http://www.cpearson.com/excel/pivots.htm

Barb Reinhardt

"Jim Kelly" wrote:

> I have a list of Data:
>
> DATA
> a
> b
> b
> c
> c
>
> How do I create a chart from this data to show:
> a 20%
> b 40%
> C 40%
>
> Do I have to perform separate calculations, or is there a way this will just
> work?
> Thanks,
> Jim