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 M6Insert 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. |
Charts >