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
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