3-variable Nomograph

[kkuebitz]

Is it possible to create a 3-variable nomograph in Excel? For example, if I wanted to create a chart where I could determine the height of water sloshing in an earthquake, I would like to assign the variable "Diameter" to the x-axis, the variable "Water Depth" to the y-axis, and the variable "Slosh Height" to the secondary y-axis (on the right side of the chart). The "Slosh Height" variable is a function of the first two variables.

With this chart, some one could trace any "diameter" vertical and a corresponding "water depth" horizontal until it intersected a curve. At this intersection, if you were to trace horizontal to the right you would find the corresponding "slosh height" on the secondary y-axis for the "Diameter" and "Water depth."

I believe this is called a Nomograph, or a parametric function.

Thanks.

[shg]

Your data regresses very well (within 0.01 for your tabulated values) to

=Depth * SUMPRODUCT(Coeff * Diameter ^ {0,1,2,3})

... where the coefficients are

8.9261E-02 -4.9567E-04 5.8259E-06 -2.5663E-08

I have to ponder how to put this in a nomograph ...

[shg]

How about instead a surface chart?