Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
3 Instances | Excel Discussion (Misc queries) | |||
linking certain instances | Excel Discussion (Misc queries) | |||
Create list of unique instances from list of multiple Instances | Excel Worksheet Functions | |||
Excel Instances | New Users to Excel | |||
Custom charting - Stacked charting with a line | Charts and Charting in Excel |