Chart showing progress

Hi All

I need to produce a chart showing the progress of pupils in Reading that are classed as 'SEN' against the progress of those who are 'Non-SEN'. The benchmark is shown in the 'AUT 1 Target' column. Based on the mark they received, they are classed as either Emerging, Expected or Exceeding.

I have attached a spreadsheet with the data and also an example of the chart i am trying to create.

Can anyone help?

Thanks

View this solution