Graphing 1x and 2y values

QuestionEdit

I'm trying to create a graph with two seperate Y axis on the left and right of my graph sharing a common X axis. It is for a pump curve and I will have PSI on the X axis and the Y axis wil be Volume and Horsepower. thanks

                         PSI			

RPM's 50 100 150 200 1760 63.0 58.6 54.5 50.7 1150 GPM 40.0 37.2 34.6 32.2 880 29.0 27.0 25.1 23.3

1760 4.0 7.5 10.4 12.9 1150 HP 2.6 4.8 6.6 8.2 880 1.9 3.4 4.8 6.0

AnswerEdit

Set up your data like this to start with: 50 100 150 200 1760 63 58.6 54.5 50.7 1150 40 37.2 34.6 32.2 880 29 27 25.1 23.3 1760 4 7.5 10.4 12.9 1150 2.6 4.8 6.6 8.2 880 1.9 3.4 4.8 6

Highlight the entire selection and choose your graph (2-D line?)

in Excel 2007, right-click on the graph, choose select data and then click switch row/column. Next, you'll need to select one of your HP data lines and right-click and choose Format Data Series. In the pop up menu, choose plot on secondary axis. Repeat for the rest of your HP data lines.

Inor earlier, after you choose the chart type from the wizard and select next, choose Series in Rows from the Data Range tab. As above, select an HP data line, right-click and choose Format Data Series. Choose the Axis tab and plot series on Secondary axis. Repeat as necessary.

-Craig