Well the problem is that I am not sure how to do that. the B values are not
simply a formula based on the A values. It goes through an entire process.
But if you could tell me how to do what you have suggested that would be
great.
Thanks

"Del Cotter" wrote:

On Sun, 12 Aug 2007, in microsoft.public.excel.charting,
Raget said:
I have one summary page where I can change values and be given the results
on the same page, whilst all the background work goes on in other sheets.
Is it possible to insert a graph that follows the value of one cell as the
value of another changes. That is, it tests values (say between 1 and 100) in
A1 and plots the effect of this on B1. I cant actually just fill for all the
values because its all based on this one cell (A1), so i have to change it
manually for different answers.

Create a pair of columns, the first of which models a population of
example values for A1, and the second of which reads that population and
calculates what the equivalent B1 would be.

I must confess I'm not seeing what your problem is.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.