Hi, I want to assign colour to certain bars in my pivot chart. for example i have three different column values in the pivot chart and i want to assign the colour so that when the pivot chart is refreshed or the range is extended thie colour remains.

I've heard that this may not be possible.

Can anyone help.