Creating chart with two variables and related trendline equation

[sudhanshu]

HI

I am trying to create a chart and trendline for a data set to be used
for interpolation/forecasting.

Following is the data set:

X-axis Y-axis ------------>>>>>
Rel Humid PO PO PO PO
@0deg @15deg @30deg @30deg
0 1.0000 1.2 1.4 2
10 1.1000 1.4 1.48 2.2
20 1.2000 1.6 1.56 2.4
30 1.3300 1.8 1.64 2.6
40 1.4600 2 1.72 2.8
50 1.5900 2.2 1.8 3
60 1.7200 2.4 1.88 3.2
70 1.8500 2.6 1.96 3.4
80 1.9800 2.8 2.04 3.6
90 2.1100 3 2.12 3.8
100 2.2400 3.2 2.2 4

The chart is created with Rel. Humid as X axis and Power Output at
various ambient temperatures (specifically for 0, 15, 30 and 45 degrees
is plotted) on Y axis.

Following are the problems :

1) How to create a 3-D chart with above data set.

2) How to obtain an trendline equation for “Power Output” wherein two
inputs are required viz. Rel. Humid. and Amb. Temp. ie. How to know
Power output at lets say at 32 degrees and rel. humidity of 75%.

3) Is there any way to link the trendline equation to a set of input
data and automate the process.

Thanking you in advance.
Sudhanshu