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.