Charts‎ > ‎

Cht4-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 
        change Type to a column or line,  as required
        for the average line add a Point Size ( choose 7px)