Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
two value axes in an excel line chart
1 view
Skip to first unread message
neural_jam
Nov 21, 2009, 6:51:02 PM11/21/09
to
How do I create two value axes in excel?
For example, I have two correlated sets of values:
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
Nov 22, 2009, 12:37:21 AM11/22/09
to
If by 2 value axis you mean you want numerical values on both the
horizontal and vertical axes, select a XY Scatter chart.
horizontal and vertical axes, select a XY Scatter chart.
Regards,
Tushar Mehta
Microsoft MVP Excel 2000-present
www.tushar-mehta.com
Excel and PowerPoint tutorials and add-ins
0 new messages