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