View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dax Arroway Dax Arroway is offline
external usenet poster
 
Posts: 70
Default Charting % of Instances

I need a chart that shows a number of times that someone's been through our
system.

I have a list of names in column B. Some are there once, some are repeated
once, some twice, some three times. I'm looking for a way of pie charting
the amount of times someone's been through. For example the pie might be 50%
of the people have only been through once, 25% have been through twice, and
the other 25% have been through 3 times; these results gathered by counting
and comparing the names in the B Column.

I'm not sure how to do it. I'm thinking =COUNTIF into a blank column which
I can then output to a pivot table which I can get a pie chart from but this
may be WAY overthinking/funcitioning it.

Any help?
Thanks in advance!
--Dax

--
I would give my left hand to be ambidextrous!