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 problems?
Best regards
Christian Ulrich
Bookmarks