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