PDA

View Full Version : Sorting and Charting multiple Ranges



MrAshton
03-14-2008, 02:14 PM
I am charting some data and would like to be able to select multiple ranges
I have already defined my ranges
we'll call them count400 all and cats400
count400all makes up [C2:C12]
cats400 makes up [A2:A12]

I sort the entire table by the values in Column 'B' in descending order
I do this so that I can chart the values in B in descending order with Column A as the category labels.

I then need to display another chart with the values of column 'C' in descending order.

How can I do this without messing up my first chart. When I sort by Column C.. the values in column B and A go with it and therefore my previous chart changes appearance accordingly.

Help plz!