[right click|save as] — 8 MB

This is the Excel Spreadsheet that produced the Temperature of Planet Earth graph.


rev 7, Mar-2014: Released.
rev 7a, Nov-2014: Added Zachos et al 2008 to panels 3 & 4 for ease of comparison (hidden; manually select the series to turn on the trace). Corrected minor graphics issues in Excel 2013.
rev 8, Jun-2015: Added Friedrich et al 2012 to panel 1, for better representation of the Cretaceous. Corrected Hanson et al formulas for Zachos. Tidied graphics.


For Wikipedia .svg compatibility this graphic uses the open-source (and rather ugly) Liberation Sans font. Systems without that font installed may substitute for rendering, possibly at detriment to the graphical layout. Liberation Sans can be downloaded and installed from here.


CC BY-SA 4.0 Creative Commons Attribution-ShareAlike 4.0 International. Attribution is required.

Copyright to the embedded raw data may be the property of others; refer to the source links on the data sheets.

7 comments to All_palaeotemps.xlsx

  • Alison Moodie

    Trying to find out who constructed this fabulous grapic, so that I can credit you!

  • Alison Moodie

    Trying to find out who constructed this fabulous graphic, so that I can credit you!

  • Kip

    Any chance for another update? It has been 5 years.
    Thanks very much for the graph, I had no idea Excel was capable of producing such fine graphics.

  • Milad Khosravi

    Hi dear Glen

    How Can I cite Temperature of Planet Earth graph in my paper?


  • Simone Nunes Brandao

    Hi, Greg, I read you recomending to cite this webpage, but webpages are unstable, destinated to die out somewhen… So, I was wondering if you wouldn’t like to provide me with your name? So I could cite this graph as:
    Surname, Name. Year. Temperature of Planet Earth graph. downloaded from Accessed on XX/XX/XXX
    I would like to use it in a outreach paper on climate change and bee, written to school teachers in Brazl.

    Best wishes,

  • Robert Keyse

    The Eemian (last interglacial between 130 and 115 thousand years ago) saw a global average temperature rise of about 5 to 6 deg. C with a CO2 rise of about 100 ppm (from 185 ppm to 280 ppm) – the rise taking about 10000 years. The onset of the Holocene 10 to 20000 years ago also saw a CO2 rise from 185 to 280 ppm and a similar warming, but ultimately to about 1 to 2 degrees C below what we see in Eemian times. Is it crazy to say a delta CO2 of 100 pm leads to a delta Temp. of about 5 degrees C?

    So we are currently going from 280 ppm to maybe 430 ppm – perhaps a delta of 150 ppm – optimistically speaking since CO2 went up 15 ppm every six years in the 21st century – Is delta T linear with delta CO2? Should we expect something like 9 or 10 deg C rise over pre-industrial times?

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>