Link two pivot charts such that same axis categories get same colors.

I am having trouble finding a way to link two pivot tables such that identically categories get the same colors.

John Peltier has solved a similar problem (http://peltiertech.com/WordPress/vba...ategory-label/). However, not with Pivot tables and I don't want to specify colors manually for every index. Each category is an index and there are many, such that I don't want to define a color for each index. Usually no more than 10 indexes will be chosen, such that I max needs 10 different colors.

Does anyone have suggestions on have I can solve this problem?

Best regards

Christian Ulrich