Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
jim_chan
Specialist
Specialist

How to add a color for a label text in a pivot table

Hi there,

For example, i have a expression called - Month Actual  $(vMaxMonth) $(vMaxYear) , how can i add a color text code in it??? something like RGB(0,0,0) ?

Rgds,

Jim

3 Replies
avinashelite

c1.pngGo to expression > here you will see a + mark , click on the plus mark and you could paste your expression for the background color in the background expression

If you want to change the label color then,

1.Enable Design Grid from Design

2.Right click on the header label

3.Select Custom format cell

4.background color

c2.png

tamilarasu
Champion
Champion

puttemans
Specialist
Specialist

Within the Chart properties - Visual cues sheet, you may insert border values for your expression, and add colour codes (max 3)