LouShepherd0921
New Member
- Joined
- Mar 14, 2006
- Messages
- 4
Excel 2010-
I want to draw a line chart with the x-axis values in one range and the y-axis values in another range. Both ranges contain values from 0.00 to 1.00.
The 2 columns might look like this:
0.56 0.01
0.78 0.19
0.91 0.58
So the first point would be 0.56 on the Y axis and .01 on the X axis, the second would be 0.78 on Y and 0.19 on X etc.
Also both the X and Y axis labels should span from 0 to 1 at .10 intervals.
For some reason I've been working with trying to do this for quite a while with no success. I would really appreciate it if someone could get me going in the right direction. It could be in the form of a macro or just using the steps in creating the chart in the worksheet.
Thanks,
Lou
I want to draw a line chart with the x-axis values in one range and the y-axis values in another range. Both ranges contain values from 0.00 to 1.00.
The 2 columns might look like this:
0.56 0.01
0.78 0.19
0.91 0.58
So the first point would be 0.56 on the Y axis and .01 on the X axis, the second would be 0.78 on Y and 0.19 on X etc.
Also both the X and Y axis labels should span from 0 to 1 at .10 intervals.
For some reason I've been working with trying to do this for quite a while with no success. I would really appreciate it if someone could get me going in the right direction. It could be in the form of a macro or just using the steps in creating the chart in the worksheet.
Thanks,
Lou