Charting flood data

[Guest]

Does anyone know how to get excel to chart data on a chart like Extreme log paper or log Gumbel chart?

 

[Jerry W. Lewis]

Never heard of Extreme log paper or a Gumbel chart, but based on the
definition of the Gumbel distribution at Mathworld
http://mathworld.wolfram.com/GumbelDistribution.html
I presume that it plots ln(-ln(y)) vs. x

That is not a chart option in Excel, but you can calculate ln(-ln(y)) in
a separate column and plot it directly.

Jerry

 

[Jon Peltier]

You can use a technique like this:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

to make the axis display the way you want it.

- Jon

 

[Jerry W. Lewis]

Very nice. I will add that to my bag of tricks.

FWIW my Greek classes were many moons ago, but I do recall that zeta
comes between epsilon and eta ;-)

Jerry

 

[Jon Peltier]

Doh! I should know that, too. My wife's family is Greek.

- Jon