Presenting Information with Charts
Spreadsheets may be great for analysing data but rows and columns
of figures may not tell the story very effectively. Above is some
data about how confident staff at institutions surveyed, in various
age groups, feel about using different applications and equipment.
The ‘Benchmark’ is the level expected for their roles.
It’s not terribly obvious at first glance what these results
The chart below, however, makes it much clearer.
The under 25s are generally pretty confident whilst the 45-54 group
would benefit from some training in finding and utilising images
effectively. Similar charts could be produced for the other categories.
Not all charts would work though.
1. Your task is to create suitable charts for each of the 9 skill
categories in the data above. They do not need to be blobs like
this illustration but you do need to check that the type you have
used does actually show sensible and meaningful comparisons between
each age group for each skill.
2. Label the chart suitably with a title ‘Using [Skill]’
and ‘Confidence level’ on whichever axis you have used
for the scores. There should be clear identification of the different
3. Either add a line or use colours (or both) to show whether each
age group’s score is below, at or above the ‘Benchmark’
[more notes on chart types]