Hi nick g. Assuming your Y data is in A1:A100 and your X data is in B1:100,
select A1:B100, click on the chart icon and select the type of chart you
want. However, the X axis data will not change automatically with a change
in the Y axis unless it is a function of the Y axis. For example: A1 = 10,
B1=A1*12/30. HTH
--
Sincerely, Michael Colvin


"nick g" wrote:


I need to plot two sets of numbers in a line chart. Both are derived
from the one spread sheet - so, if I change one input (the y axis
entries) a corresponding new value is generated by the spread sheet for

the X axis.

I want to do this for 100 y axis entries. How do I pick up the x axis
numbers coprresponding to each y axis entry AUTOMATICALLY so that the
corresponding x and y values can be brought together using the standard

chart wizard?

This is a question of maximum ignorance frmo a self-taught excel-er .
Any help gratefully appreciated.

tks


--
nick g
------------------------------------------------------------------------
nick g's Profile: http://www.excelforum.com/member.php...o&userid=25475
View this thread: http://www.excelforum.com/showthread...hreadid=389291