Charts from Spread sheets

[nick g]

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

 

[Guest]

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

 

[nick g]

Thank you,

Unfortunately there is not a linear relationship between the x and the
y axis entries. The resultant line using my data should have a kink in
the middle as the curve flattens in the middle before resuming its
original path.

SO I need to find a way, for each of my 100 y axis entries, to pick up
the corresponding x axis entry as derived by my devilishly clever
series of logical if functions !

I am sure I have seen excel buttons which you program - are they
macros? - which would, for each of my 100 y axis entries, run my
formulae and then record the result before moving on to the next. THEN
I could plot one set of data against the other. Any thoughts?

Many thanks for holding my hand on this one.

 

[Guest]

Sorry about the delay in replying, Nick G. I've been out for awhile. I'm
sure there is a way to accomplish what you want, but It's over my head.
Hopefully, one of the MVP's who frequent this site will read your post. Good
Luck.