Dynamic Chart Type when Using a Multiple Consolidated Range Pivot Table

[HangMan]

I have a PivotTable constructed using Multiple Consolidated Ranges (basic sample attached).

Is there a way to dynamically (or otherwise) change the 'Chart Type' based on the 'Report Filter'? In the attached sample, I would like the Chart Type to be a 'Column Chart' when the 'Page 2' Report Filter says 'Monthly' but for the 'Chart Type' to automatically change to a line chart when the 'Page 2' Report Filter is changed to 'Cumulative'. Note: This will be Excel 2010 distribution.

I will be using Pivot Slicers in the finished version and the actual graph will appear on a seperate worksheet to the data, so te user will only see the chart and the slicers (not the source data) but I assume the same logic applies? I'm assuming this would have to be done using VBA, but I have no ideas how this could be achieved?

There will ultimately be four Report Filters, but for now the Chart Type will only need to be affected by one of the four.

Many thanks