bdl004
09-23-2010, 01:18 AM
Hi guys,
I am stuck on a problem involving arrays (again). What I have is a bunch of names in one array (say: joe john jack jack joe joe john eric kevin) and I want to make a bar chart showing the name, and the percentage of times it occurs. I wish to sort this bar chart in descending order.
I would prefer to avoid making a pivot table or writing to a sheet too much as the data series is very large.
Thanks in advance!
Brett
I am stuck on a problem involving arrays (again). What I have is a bunch of names in one array (say: joe john jack jack joe joe john eric kevin) and I want to make a bar chart showing the name, and the percentage of times it occurs. I wish to sort this bar chart in descending order.
I would prefer to avoid making a pivot table or writing to a sheet too much as the data series is very large.
Thanks in advance!
Brett