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 problems?
Last edited by cudh; 09-21-2014 at 06:09 AM.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By kheino1111 in forum Excel General
Last Post: 04-01-2014, 12:34 AM
By riya.arora. in forum Excel Charting & Pivots
Last Post: 04-09-2013, 04:55 AM
By deanf987 in forum Excel General
Last Post: 02-14-2012, 04:34 AM
By Mike in forum Excel Charting & Pivots
Last Post: 06-15-2006, 08:25 AM
By cfagan in forum Excel Charting & Pivots
Last Post: 03-03-2006, 01:10 PM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1