one simple solution:
Create separate pivot  tables (& charts) for the combinations of 'column'
selections; looks like 3 (ColumnA, ColumnB & ColumnC). Set up as usual, then
hide all but 1 pivot & chart.
Your Macro would then hide & unhide sheets (pivots & charts) depending on the
selection of primary & secondary data views:

If 'Data by Branch then by Product' selected then unhide sheets that contain
this view, hide all others.
If 'Data by Branch then by Requirement Area' selected then unhide sheets that
contain this view, hide all others.