Excelling in Excel: Data Visualisation
From Jill MacKay on August 1st, 2019
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