A graph based on the possible values in a cell
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. |
A graph based on the possible values in a cell
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. |
A graph based on the possible values in a cell
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. |
A graph based on the possible values in a cell
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. |
All times are GMT +1. The time now is 12:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com