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/
_______


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