color of label

[adiarnon]

hi,

i have a table (pivot).

i want that each expression will have a different label color.

how can i do that?

[amit_saini]

Hi Adi,

You can give condition here for each expression. See below:

[adiarnon]

tnx,

i know this.

but i need color only for the label - not the whole column....

[amit_saini]

Hi Adi,

Can you see in the image at the right top side  above Definition there is option for changing color of label.

Thanks,

AS

[its_anandrjs]

Hi,

From enable the option from menu

Settings -> User Preferences -> Design -> Checked option (Always Show Design Menu Items)

after that right click on the chart cells and change the color.

HTH

Thanks & Regards

[adiarnon]

HI,

i have done the change in the User Preferences.

what now?

[its_anandrjs]

Hi,

From enable the option from menu

Settings -> User Preferences -> Design -> Checked option (Always Show Design Menu Items)

after that right click on the chart cells and change the color.

HTH

Thanks & Regards

[its_anandrjs]

Hi,

Save it and right click on the chart cell and change background color according to you.

Thanks & Regards

[adiarnon]

hi,

tnx!!!

but its changing all the labels of all of the expression.

is there any option to choose different color of each expression label?

[Colin-Albert]

I dot believe you can set a different background colour for each dimension label.

This item shows how to set a different background colour for the data based on the dimension.

Coloring the background cells in Pivot Table based on value in cell