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