[JPWork]

Hello,

I am trying to make a rather large workbook full of different sheets which each have a the same pivot table pulling the same range of data but with a different filter on. For example worksheet 1 filters to only show Person 1 and worksheet 2 filters to only show Person 2. Each sheet will contain one pie graph, my issue is that I want all the pie graphs to have the same colour scheme.

They seem to work on a colour wheel, that is, the pivotchart assigns the first value blue, then red, and so on.

To give you more detail,

Person 1 may have the following info:
Toronto
Chicago
Mumbai
Sydney

Person 2 will have:
New York
Sydney
Toronto
Ottawa

Manager 1 and 2 have Toronto and Sydney in common but Person 1's Toronto may be blue whereas Person 2's Toronto is red and so on. Is there a way to set a rule that defines what the colour may be across the workbook?

Thanks for your time