Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
two value axes in an excel line 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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Bar and Line chart on 2 Axes | Charts and Charting in Excel | |||
How to change bar to line in line-column on 2 axes chart in Excel2 | Charts and Charting in Excel | |||
Chart : 2 axes stacked bar and line | Excel Discussion (Misc queries) | |||
How to add a Vertical Line to a Column or Line Chart with two axes already in use? | Charts and Charting in Excel | |||
How to create a line chart with two X-axes in Excel | Excel Discussion (Misc queries) |