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 from 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=389460