View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Tushar Mehta Tushar Mehta is offline
external usenet poster
 
Posts: 126
Default two value axes in an excel line chart

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