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?

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

On Sat, 21 Nov 2009 15:51:02 -0800, neural_jam
<neural_jam@discussions.microsoft.com> wrote:

>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