I need to plot multiple series from one table, all of the series on the same graph.. So when I add new data to the table I don't have to reselect all the series for the appropriate graphs. I would like to select the series column and then plot the following:
- d vs. Torque
- d vs Price
- Torque vs Price
Sample Data:
SERIES d(X) Torque Cost
RFN 70 120.00 10.00
KKG 70 110.00 12.00
PPG 80 150.00 14.00
SAP 70 110.00 19.00
RFN 80 115.00 14.00
RFN 90 130.00 20.00
PPG 70 125.00 11.00
SAP 100 145.00 35.00
KKG 100 160.00 25.00
SAP 90 135.00 25.00
SAP 100 170.00 50.00
PPG 80 130.00 16.00
Is there a quicker way(less tables. etc) of doing it than: Excel scatter plot with multiple series from 1 table
Otherwise I need to create a table for each plot that I want to create?
Thank you
