Hi,
I have a PivotTable set up for a number of regions (columns) and a number of rows, about 25, for various revenue centres. I have the values as a % of column. However a number of the revenue centres are irrelevant and i have filtered for the top 10 revenue centres then set up a PivotChart...