A short series aimed at
upskilling distance learning students on how to make the best use of excel. In
this lecture I cover how to create charts in Excel.
00:44: Difference
between figures, charts and infographics
02:11: What makes a good
chart?
03:25: Aspects of good
charts
04:40: Aspects of bad
charts
05:38: When should I use
bar charts?
06:41: When should I use
scatter plots?
07:20: Examples of very
bad charts
08:02: Make a chart in
excel with me
29:00: Make a bar chart
in excel – more complicated charts
38:36: Colour in charts
39:38: Chart doctor
links: How to navigate data’s pink and blue problem: https://www.ft.com/content/c4b7d8be-2eb0-11e8-9b4b-bc4b9f08f381.
Design secrets behind the FT’s best charts of 2017: https://www.ft.com/content/4743ce96-e4bf-11e7-97e2-916d4fbac0da