The secret – usually forgotten sauce to creating charts in Excel is to make sure your data is properly organised – no blank rows, no blank columns and you need to go all – what I call – Judge Judy on it – “The data, all the data and nothing but the data”. This video shows you how to do it..

You can download the file I use here