The number that you are changing (0 to 5) should of been a cell in the
worksheets not hard coded. Then the table that you using should reference
the cell which contains 0 to 5

for example if you graph was based on the following table

old table
A B
1 =3 * 5 =3 * 10

2 =3 * 7 =3 * 15

The new table now has D1 instead of 3. Then change D1 to be 0 to 5 and the
graph will automatically change

new table
A B
1 =D1 * 5 =D1 * 10

2 =D1 * 7 =D1 * 15

"Bob Phillips" wrote:

An example of the data and any formulae you are using might enlighten us.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"theredspecial" wrote in message
...
i've build a model in excel.
on the basis of a few variables i made quite a number of sheets. one
variable i had to keep constant, otherwise i would need 3d tables. now
that
the model is almost done, this one variable needs to change.
it needs to take discrete values between 0 and 5 (for example, and in
steps
of .25) the change of this value has to be calculated in the model and the
result needs to be in a table. every result (which will be 4*6*something)
need to be visible, as they will be used in a graph.
(am i still clear?)

now, how do I change that one value and allow excel to draw the graph?
(if you need more information, ask your question and i will try to answer
them)