I have a pivot table that needs a chart from part of it (My Brand).
The pivot table is made up of Market data and my brand data where the result shows %Of.
This means that if I attempt to hide market data the whole thing collapses.
I just want the chart to Show my Brand %Of figures and due to...