Cht3 - History of Marks

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

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