| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
In excel, how do I vary a cell over a data range & see its effect?
I would like to plot a chart where values of a cell vary over data range and
effect of this change are seen on a related cell. I could have copied the cells and the formula as many times as the number of values of the first cell. Wanted to have a smarter way. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
In excel, how do I vary a cell over a data range & see its effect?
The simpler way (and therefore usually smarter) is to copy the formula as
many times as you need points. A trickier way which only requires the formula to be used once is to set up a data table in the worksheet. Here is a tutorial: http://www.ce.cmu.edu/~hsm/bca2005/l...chrome2001.pdf - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Bimal" wrote in message ... I would like to plot a chart where values of a cell vary over data range and effect of this change are seen on a related cell. I could have copied the cells and the formula as many times as the number of values of the first cell. Wanted to have a smarter way. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INDIRECT / Setting to vary a range? | Excel Discussion (Misc queries) | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| Excel Cell Criteria Effect | Excel Worksheet Functions | |||
| How can I vary graph color by range value | Charts and Charting in Excel | |||
| Excel printing problem - won't print cell under a "fill effect" bo | Excel Discussion (Misc queries) | |||
Hybrid Mode
