+ Reply to Thread
Results 1 to 4 of 4

Plotting monthly atmospheric CO2 concentrations over time

  1. #1
    Registered User
    Join Date
    03-28-2015
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    8

    Plotting monthly atmospheric CO2 concentrations over time

    Hello,
    I have 3 columns of data - year, month and atmospheric CO2 (ppm).
    The first 3 years look like this to give you an idea.

    1960 1 316.43
    1960 2 316.97
    1960 3 317.58
    1960 4 319.02
    1960 5 320.03
    1960 6 319.59
    1960 7 318.18
    1960 8 315.91
    1960 9 314.16
    1960 10 313.83
    1960 11 315
    1960 12 316.19
    1961 1 316.93
    1961 2 317.7
    1961 3 318.54
    1961 4 319.48
    1961 5 320.58
    1961 6 319.77
    1961 7 318.57
    1961 8 316.79
    1961 9 314.8
    1961 10 315.38
    1961 11 316.1
    1961 12 317.01

    How do I plot it so year is on the x-axis, ppm on the y-axis, and the monthly fluctuations are seen on the scatter graph so it ends up looking like the Keeling curve? http://en.wikipedia.org/wiki/Keeling_Curve

    I hope that's clear, any help very much appreciated!

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Plotting monthly atmospheric CO2 concentrations over time

    Welcome to the board.

    Row\Col
    A
    B
    C
    D
    E
    1
    Y
    M
    PPM
    X
    2
    1960
    1
    316.43
    1960.00
    D2: =A2 + (B2-1)/12
    3
    1960
    2
    316.97
    1960.08
    4
    1960
    3
    317.58
    1960.17
    5
    1960
    4
    319.02
    1960.25
    6
    1960
    5
    320.03
    1960.33
    7
    1960
    6
    319.59
    1960.42
    8
    1960
    7
    318.18
    1960.50
    9
    1960
    8
    315.91
    1960.58
    10
    1960
    9
    314.16
    1960.67
    11
    1960
    10
    313.83
    1960.75
    12
    1960
    11
    315
    1960.83
    13
    1960
    12
    316.19
    1960.92
    14
    1961
    1
    316.93
    1961.00
    15
    1961
    2
    317.7
    1961.08
    16
    1961
    3
    318.54
    1961.17
    17
    1961
    4
    319.48
    1961.25
    18
    1961
    5
    320.58
    1961.33
    19
    1961
    6
    319.77
    1961.42
    20
    1961
    7
    318.57
    1961.50
    21
    1961
    8
    316.79
    1961.58
    22
    1961
    9
    314.8
    1961.67
    23
    1961
    10
    315.38
    1961.75
    24
    1961
    11
    316.1
    1961.83
    25
    1961
    12
    317.01
    1961.92
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    03-28-2015
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    8

    Re: Plotting monthly atmospheric CO2 concentrations over time

    You are an absolute genius thank you so much!

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Plotting monthly atmospheric CO2 concentrations over time

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. PLotting a simple line graph with monthly sales averages
    By EXCEL vs SQL in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-11-2014, 12:02 PM
  2. Replies: 5
    Last Post: 08-03-2012, 01:43 AM
  3. Plotting Time
    By thisandthat in forum Excel General
    Replies: 1
    Last Post: 06-21-2011, 08:05 PM
  4. Plotting time vs. day of the week
    By texknight in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 06-11-2009, 05:14 PM
  5. plotting time
    By john mcmichael in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-01-2005, 06:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1