Thread: [Solved] Generate chart from list of text values
View Single Post
 
Old 04-24-2013, 01:56 AM
c0rt0 c0rt0 is offline Mac OS X Office for Mac 2011
Novice
  
Join Date: Apr 2013
Posts: 1
c0rt0 is on a distinguished road
Default
I am in a similar situation, trying to figure out a way of A. Grouping text values, that you demonstrate very well but also B. take into account a second column and add the sums?

So for example if:
Mike 100
Sue 250
Bob 150
Mike 50
Sue 300

How could I make a chart with all instances of the same person grouped in one and get only the totals?
Reply With Quote