Learn how to use Excel - please

After my recent postings, I was sent this from a colleague - and actually it's not a bad stab at representing the data - just the execution and lack of Excel-fu lets it down:

In essence, it's a panel chart - but drawn as a bar chart, comprised of 10 series - which Excel has obligingly colour coded. But to be honest, all I can see is that (as you would expect) you get more learners getting the grades as you go from A* to A to B etc.

Not sure what parents are supposed to extract from this.

The same data can be easily represented as:

At least with a proper panel chart I can see the underlying trends for the grades - which for the A*-A seems to be quite an increase from 2003 to 2013 - however, what I can now also see is that the A*-B and A*-C seem to decline slightly over the past 5 years.

I'm not sure what value a parent (or anyone else for that matter) would get from this visualisation - the chart would appear to show an improving situation over time - with more and more learners "passing" with A*-C grades.

But what about the grades themselves?
Taking the A* results from the A*-A, and the A*-A from the A*-B etc will give us the actual numbers achieving each grade:

The same data, but a different picture.

Here I can see that the all grades A, B and C have (over the past 5-7 years) seen a year on year decline - what looks like a different picture.

I'm not sure which view is more useful - but I suspect that this is a case of "don't use a chart"

From 2003 - 2012, the average A*-C is 97%

...would appear to be a stronger message than the charts themselves - and if a chart is desired, add the averages:

Call to action
  • Don't overload colours - not only does it look poor, it actually makes things harder to understand
  • Learn Excel charting functions, such as panel charts
  • Don't use a chart when text will do
  • Annotate charts with averages to make the interpretation easier

comments powered by Disqus