Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to make the background color of the Total row of a Straight Chart as Yellow. It should be done completely i.e. Dimensions as well as Expressions. Right now I can only do the Expressions portion through Visual Cues.
Is it supported currently?
Thank you.
Go to Settings --> User Preferences --> Design and enable the option "Always Show Design menu Items"
Then right click on the totals row --> Custom Format Cell and change color, border, font etc.
Check out the attached example
Go to Settings --> User Preferences --> Design and enable the option "Always Show Design menu Items"
Then right click on the totals row --> Custom Format Cell and change color, border, font etc.
Check out the attached example
Thank you, very helpful.
One thing to add, it works great with Straight Charts but Pivot Tables are little hard for this option.
Yes, true, but this is the easiest way to go. Otherwise you need to fake the total rows, which I strongly do not recommend. Please close this discussion, if you are satisfied.