secundary X axis in an Arrhenius plot

[bandjo]

On an arrhenius plot you are plotting a growth rate versus the inverse of the
absolute temperature. It is leading to strange numbers on a first X axis. I
saw sometimes plots showing the temperature in celsius on a secundary X axis
on the top of the graph. This way it is more readable and the reader of the
document is aware in which temperature range you have been working.

 

[Bernard Liengme]

In an Arrhenius (please give him a capital A), as in all physical chem
problems, temperature is measured on the Kelvin scale. Try making a T column
=ºC +273.2

 

[bandjo]

Thanks

I know about the first axis. I am actually wondering how to have the
secundary X axis showing the original celsius temperature but in a kind of
hyperbolic scale as the temperature on second X axis must correspond to the
inverse of T on the first one. If I do the transformation myself I will have
to put some labels at teh right place instead of using the automatic scale
labelling

Thank you again

 

[Jon Peltier]

You can see how to do this on my web site:

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

This second link shows an Arrhenius plot. While it's done with labels, using a
helper series puts the labels in the proper places along the axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______