Hi,
What I am trying to do is use the data from each months tab and create a pivot table showing the totals for each month in the Totals tab.
I would like to display the Categories down the left and one month per column across the top. The idea is then to create a line chart for each catergory so I can visualise how we are tracking as the year progresses.
I have worked out how to put the data into one pivot table but can't get it to display the way I would like it to.
Could anyone help please?
Thanks
TomDummy Workbook.xlsm
Bookmarks