Hi!
I am trying to set up a pie chart using 2 columns of data- one is a list of money amounts and the other is a list of the state it came from. I need a pie chart that gives me a break down of money by state. When I set it up and put the 2 columns in as seperate values it treats each line as something by itself, meaning new york is there 50 times as 50 seperate colors of the pie- I need it to combine all "NY" into one color. Anyone know how i do that??
Thanks!!!