How to do an Arrhenius plot AKA How to do a reciporcal secondary axis in Excel 2010?

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:

Picture Source

The second axis is only for better readability and is corresponds to the primary axis with the relation:

``````primary=1/secondary

secondary=1/primary
``````

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

• I don't think it would be possible neither with neither without VBA. You can get close by manually creating the secondary axis and placing it over your chart. – Máté Juhász Nov 12 '18 at 9:54
• @MátéJuhász yeah.. I feared that the manual solution was going to be the final verdict. Ok better get started on the coding then. – Lucas Raphael Pianegonda Nov 12 '18 at 10:22
• You may also want to consider PowerBI and R. With their integration with Excel, you may be able to accomplish your task without too much trouble. – dav Nov 13 '18 at 20:03

This link excplains how it is done. This would also work for other scaling axis like square root ect. Here a small outline of how you do it:

Create your ticks as a series:

• calculate all axis ticks you want the x's of a series
• all y's of the series need to be exactly the lowerlimit of your y axis (or the upper limit if you want your axis to be on top)