LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
3 Instances hpoincare Excel Discussion (Misc queries) 1 September 29th 08 03:59 PM
linking certain instances RedFive Excel Discussion (Misc queries) 2 September 19th 08 04:59 PM
Create list of unique instances from list of multiple Instances Dishon Excel Worksheet Functions 0 March 3rd 08 10:46 AM
Excel Instances StephanieH New Users to Excel 3 November 17th 05 07:34 PM
Custom charting - Stacked charting with a line Randy Lefferts Charts and Charting in Excel 3 March 3rd 05 03:10 AM


All times are GMT +1. The time now is 02:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"