Charts‎ > ‎

Cht3 - History of Marks

Enter the data in a Google spreadsheet

Select the  range from A3  to E7
Use row 3 as headers
Adjust the titles, legends etc as required

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).
    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)

    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