Enter the data in a Google spreadsheet To create this second graph, you will need to calculate the average for each year. Select the required data (similar to the first example, but include the yearly average you calculated). Start: Switch rows and columns Use Column A as headers User Row 3 as labels Choose the Combo Chart (don't worry if there are too many lines, you will change this later) Customize: adjust the titles, legends etc as required Data Series: for each data series, Math, Science, English, History and Average set the Type to a column or line, as required set the average line Point Size to 7px |
Charts >