PDA

View Full Version : Sort Before Graphing



frdq19
12-12-2011, 11:26 PM
I am setting up various graphs based on either A vs. B (scatterplot) or %"someting" (piechart).

For both of the above, all of the cells in the two columns contain data.

Now, I need to move to the next step: a sort function prior to graphing. I can record a macro to find out the basics, but have some other problems:

1. One column will have x data, one column for the y data. BUT, a third column will have text that needs to be sorted and separated prior to graphing.

2. So, column A has three words ONE, TWO, and THREE.

3. Column B and C have corresponding data, with more than one set of values for each name in column A.

4. I need to sort by the names in column A, and manipulate the corresponding data to allow calculations on the data sets, and subsequent graphing of all results on one graph.

5. This needs to be a loop, as the number and actual text of the names in column A will be unknown.

I can explain more if this is confusing...no, I cannot use Colos' utility for many reasons.

Bob Phillips
12-13-2011, 03:40 AM
I did not understand point 5.

Can you post a file?