Setting the colour of the overall Column Header in a Pivot Table

Question & Answer
,
1

Hi

I have this analysis:

image
image894×421 22.2 KB

If I set the colour of the Rows Header here, it changes the individual rows and the overall Row Header:
image

Eg, if I change it to blue, I get:

image
image891×412 23.2 KB

The corresponding format for columns is here:
image

If I change that to green I get:

image
image904×416 23.5 KB

The overall Column Header colour is not changed.

Is this a bug?

Is there a workaround? I cannot see anywhere else where I can influence the colour of the overall Column Header.

TIA
J

2

An update …

If I drag the field from the Columns field well to the Rows field well, the overall header picks up the desired colour. If I drag it back to the Columns field well, it goes back to black!