Auotomating "Sort" in Excel
 

Hi everyoe,

Say I have data table like this

# Resp Depl AgVr Leth Surv Sust InOp
1 0.609 0.340 0.619 0.692 0.499 0.541 0.164
2 0.856 0.544 0.619 0.677 0.501 0.481 0.851
3 0.799 0.560 0.594 0.523 0.515 0.556 1.000
4 0.591 0.507 0.549 0.585 0.511 0.496 0.851
5 0.815 0.619 0.553 0.543 0.544 0.525 0.851
6 0.622 0.507 0.594 0.452 0.545 0.648 0.851
7 0.653 0.754 0.669 0.552 0.578 0.503 0.851

Before I plot each, I sort them. To do so, say wants to plot #1, I puts
them in x-y columns like this:

A B
Resp 0.609
Depl 0.340
AgVr 0.619
Leth 0.692
Surv 0.499
Sust 0.541
InOp 0.164
SoSI 0.333
RD_Cost 0.868
Pr_Cost 0.970
OS_Cost 0.941
Volume 0.622
Power 0.651
Thermal 0.648
Weight 0.824

Next, I sort them like this:

A B
Pr_Cost 0.970
OS_Cost 0.941
RD_Cost 0.868
Weight 0.824
Leth 0.692
Power 0.651
Thermal 0.648
Volume 0.622
AgVr 0.619
Resp 0.609
Sust 0.541
Surv 0.499
Depl 0.340
SoSI 0.333
InOp 0.164

Then plot them. How can auotmate this in excel to plot solution-to-plot
by "#"?

Thanks,
Mike

Auotomating "Sort" in Excel
 

Have you tried recording a macro, and assigning it to a forms button?

--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
oups.com...
Hi everyoe,

Say I have data table like this

# Resp Depl AgVr Leth Surv Sust InOp
1 0.609 0.340 0.619 0.692 0.499 0.541 0.164
2 0.856 0.544 0.619 0.677 0.501 0.481 0.851
3 0.799 0.560 0.594 0.523 0.515 0.556 1.000
4 0.591 0.507 0.549 0.585 0.511 0.496 0.851
5 0.815 0.619 0.553 0.543 0.544 0.525 0.851
6 0.622 0.507 0.594 0.452 0.545 0.648 0.851
7 0.653 0.754 0.669 0.552 0.578 0.503 0.851

Before I plot each, I sort them. To do so, say wants to plot #1, I puts
them in x-y columns like this:

A B
Resp 0.609
Depl 0.340
AgVr 0.619
Leth 0.692
Surv 0.499
Sust 0.541
InOp 0.164
SoSI 0.333
RD_Cost 0.868
Pr_Cost 0.970
OS_Cost 0.941
Volume 0.622
Power 0.651
Thermal 0.648
Weight 0.824

Next, I sort them like this:

A B
Pr_Cost 0.970
OS_Cost 0.941
RD_Cost 0.868
Weight 0.824
Leth 0.692
Power 0.651
Thermal 0.648
Volume 0.622
AgVr 0.619
Resp 0.609
Sust 0.541
Surv 0.499
Depl 0.340
SoSI 0.333
InOp 0.164

Then plot them. How can auotmate this in excel to plot solution-to-plot
by "#"?

Thanks,
Mike