Change background color of dimension title

[#1]

This is a pivot table that I like to change the background color of the title. Is it possible?

[Anonymous]

Try this:

Apply Change To: Select Expression

[awhitfield]

Sure,  check Settings User Preferences, and ensure you have 'Always Show Design Menu Items' ticked.

Right Click on one of the dim headers and select 'Customer Cell Format', then click and chose the background colour that you want.

HTH

Andy

[kaushiknsolanki]

Hi,

Go to Settings -> User Preferences -> Design Tab -> Check the box "Always show design menu items".

Click ok.

Right Click on Chart cell and you will find the option "Custom Format Cell"

Using this option you can change the color.

Regards,

Kaushik Solanki

[awhitfield]

Ha ha SNAP!

Andy

[#6]

However it will change all dimension, but I want each dimension with an unique color, it that possible?

[awhitfield · Accepted solution]

AFAIK, you would have to overlay transparent colour text boxes

Andy

[kaushiknsolanki]

Hi,

In that case go to Dimension tab in chart properties. Click + sign next to dimension, double click on Background color, here you can give your expression to give background color.

Regards,

Kaushik Solanki

[#9]

I want to change only one cell, the title 2016-04-19. By doing the way you advice will change the whole column.

[kaushiknsolanki]

Hi,

You can write an expression like below.

If(Column = 'ABC',Black(),Red())

Regards,

Kaushik Solanki