Hi
I'm trying to use a pivot table to extract data and graph Baseline vs Current in a stacked Column Graph but having all sorts of trouble with the multiple date columns, any assistance would be appreciated.
Hello Gordon,
As I see it, if you want to use the current layout of your data table/range then you need to create a "helper table/range" where you use functions to sum the Baseline and Current columns per year and month and then create a chart.
As you can see I have created two new sheets in your document, where I have restructured the data in your range.
This will give you what you look for (as I have understood your issue) when using Pivot Table and Pivot Chart.
Br,
Anders
Thanks Anders
I appreciate the efforts, this sort of manipulation is what I was trying to avoid.
Regs
G
I think no choice we have to tidy up our data before generate any sensible report.