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

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 

        change Type to a column or line,  as required

        for the average line add a Point Size ( choose 7px)