You could set up a data table:
An overview of data tables in Excel 2003 and in Excel 2007 (Microsoft)
http://support.microsoft.com/kb/282852
Data Table Basics (Daily Dose)
http://www.dailydoseofexcel.com/arch...-table-basics/
Automating without code (Dermot Balson)
http://www.westnet.net.au/balson/Mod...MaNoCode.shtml
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Raget" wrote in message
...
Hi,
I have a spreadsheet that is fairly complicated, and spreads over a few
sheets.
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.
Thanks.