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.
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 ...
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
How about instead a surface chart?
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks