two value axes in an excel line chart

[neural_jam]

How do I create two value axes in excel?
For example, I have two correlated sets of values:

x y
0.65 4.7
2.01 4.02
2.98 2.99
3.78 1.89
4.33 0.21

I want to show x as a function of y, but want each axis to show integers for
0-6 (and end up with a single line that passes through each x,y coordinate).

How do I do this?

 

[Tushar Mehta]

If by 2 value axis you mean you want numerical values on both the
horizontal and vertical axes, select a XY Scatter chart.

How do I create two value axes in excel?
For example, I have two correlated sets of values:

x y
0.65 4.7
2.01 4.02
2.98 2.99
3.78 1.89
4.33 0.21

I want to show x as a function of y, but want each axis to show integers for
0-6 (and end up with a single line that passes through each x,y coordinate).

How do I do this?

Regards,

Tushar Mehta
Microsoft MVP Excel 2000-present
www.tushar-mehta.com
Excel and PowerPoint tutorials and add-ins