So we are now up to seven of the eight part  series I am doing on pivot tables. You can check out parts one, two, three, four, five and six here.

In Excel 2007 (and later editions) the charting facility with your pivot charts gives you a huge amount of flexibility. However, if you need to create charts and you don’t have a pivot table, here’s a tutorial on how to do it.

See below…



As always here is the file for you to practise on.