Ultimate circular problem for chart creation

[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 from a self-taught excel-er .
Any help gratefully appreciated.

tks

 

[Jon Peltier]

The easiest thing to do is put the X and Y values into adjacent columns,
and select these two columns when creating the chart.

Do you want a line chart or a scatter chart? The line chart gives you
equally spaced X ticks across the bottom, regardless of their numerical
value, while the scatter chart spaces points according to the actual X
values. A scatter chart series can be formatted with lines connecting
the points.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______