Formatting a Table correctly for a Pivot Chart

You are in luck. You have Excel 2010 or better which means you have slicers. Slicers are more than fancy filters; they can also be used to control multiple pivot tables at once!

Do a web search on slicers. They are actually quite intuitive but also very powerful.

To get you started on your issue:
- Select a cell in the pivot table
- Select Insert from the main ribbon and then Slicers (it's about 2/3 rds of the way over)
- This will give you a list of columns in your spreadsheet
- Select Section and you are done

One of the nice things about slicers is that they do not have to be part of the pivot table itself. The only requirement is that they have to be part of the source data for the pivot table. Also slicers are "cascading" meaning that the selection of a value or values in one slicer may affect what can be selected in the remaining slicers. For example. suppose you had 2017 data for June to December and 2018 data for January to March. If you select 2017 in the Year Slicer, you will only be allowed to select June to December in the Month Slicer, If you were to clear the year filter and select February in the Month Slicer, only 2018 will be available in the Year Slicer.

That's perfect! May I ask how you transformed my existing table into that? Many thanks!

Edit: I've opened the workbook you attached in Excel 2010 which may not have it and would be the reason why I can't find it, I'll have a proper look when I'm at work tomorrow! Thanks.