| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
referencing a value from a chart with 3 variables
Is it possible to have a value (that doesn't seem to have a simple
mathematical formula) appear in a cell from a chart that is dependent on 3 variables? More specifically, a pressure rise is obtained from a chart. This value for the pressure rise depends on the specified model of heater used, the specified cubic feet per meter, and the specified temperature rise. I want to have the value of the pressure rise automatically appear when the other three values are entered from drop down lists. Help me if you can. Thanx |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
referencing a value from a chart with 3 variables
You will need to find a equation that fits the data. Begin by looking at
"trendline" in Help then come back with more questions best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "KP@RG" wrote in message ... Is it possible to have a value (that doesn't seem to have a simple mathematical formula) appear in a cell from a chart that is dependent on 3 variables? More specifically, a pressure rise is obtained from a chart. This value for the pressure rise depends on the specified model of heater used, the specified cubic feet per meter, and the specified temperature rise. I want to have the value of the pressure rise automatically appear when the other three values are entered from drop down lists. Help me if you can. Thanx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a combo chart plot 4 variables? (3 bars,1 line) | Charts and Charting in Excel | |||
| Pivot Chart - Remove Variables | Charts and Charting in Excel | |||
| Selecting part of a series for a chart? | Charts and Charting in Excel | |||
| Activating a Chart object | Charts and Charting in Excel | |||
| tick mark labels | Charts and Charting in Excel | |||
Hybrid Mode
