Thread: assign permanent colors to bars/values in a pivot chart
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Rose73
 
Posts: n/a
Default assign permanent colors to bars/values in a pivot chart
I have a column in my source data called "TIER" so the values are 1, 2, 3
etc. when I convert to a pivot chart I want those values/bars to be
automatically & permanently assigned a specific color. Eg. Tier 1 = Green,
Tier 2 = Yellow etc.

Can you help?
Reply With QuoteReply With Quote