Charts from Spread sheets

  • Thread starter Thread starter nick g
  • Start date Start date
N

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
 
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
 
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.
 
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.
 
Back
Top