Cht4 - Climograph

Mixed Line and Bar Graph -- Google calls this a Combo chart -- with two vertical axis with different scales

Enter the data below into a Google Spreadsheet

Select all the data in the range A3 to M6

Insert a Chart

Start:

    Select the Combo chart

    you may need to switch the rows and columns

    Use column A as headers

Please note: the graph starts to look worse before it starts to look better!

Customize:

    Add titles, Legends, etc. as required.

    Axis

        Horizontal Axis

            add the title

        Left Vertical

            add the title   

            set Min to 0 and Max to 400

            Gridlines: 9

    Data Series:

        Temp C

            Type:  Line

            Axis: Right

            Point Size: 7px        

        Ppt(mm)

            Type: Columns

        Growing Season

            Axis: Right

    Axis

        Right Vertical 

            add title

            set min to -40 and max to 40

            Gridlines: 9

   Adjust the colours of the lines and columns as required.