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

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

Rick wrote:

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

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Jerry W. Lewis wrote:

> 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
>
> Rick wrote:
>
>> Does anyone know how to get excel to chart data on a chart like
>> Extreme log paper or log Gumbel chart?
>
>

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 wrote:

> 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
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> http://PeltierTech.com/Excel/Charts/
> _______
>
> Jerry W. Lewis wrote:
>
>> 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
>>
>> Rick wrote:
>>
>>> Does anyone know how to get excel to chart data on a chart like
>>> Extreme log paper or log Gumbel chart?

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

- Jon

Jerry W. Lewis wrote:
> 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 wrote:
>
>> 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
>> -------
>> Jon Peltier, Microsoft Excel MVP
>> Peltier Technical Services
>> http://PeltierTech.com/Excel/Charts/
>> _______
>>
>> Jerry W. Lewis wrote:
>>
>>> 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
>>>
>>> Rick wrote:
>>>
>>>> Does anyone know how to get excel to chart data on a chart like
>>>> Extreme log paper or log Gumbel chart?
>
>