An Arrhenius plot show the logarithm of a property that is thermally acitavted versus the reciprocal temperature aka 1/T. Now is 1/T something that most people are not used to. This is why most of the plot also contain the translation in temperature on a second axis. Usually on top of the graph. The output should look like this:
The second axis is only for better readability and is corresponds to the primary axis with the relation:
What I am not able to do in excel 2010 is the reciprocal second x-axis. Is there a way to do this?
A secondary problem is that I am not able to insert a secondary axis in a XYScatterplot
Problem 1: How to format an axis reciprocal (1/x)?
Problem 1b: How to properly add a second x axis in a XYscatterplot?
Note: If you know a solution to this using Macros (VBA) then my related question on StackOverflow is here