Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using a Pivot Table and would like to change the font size of one of dimensions. I have tried <H6> however its not working.Also i want to hide the name of one of the dimension and don't want to change anything in the script.
Please help.
Thanks
Hi Ankit,
We can change font size one of dimension body. for all i know can not change particular dimension header, however can change for all dimension headers.
To hide the name of the dimension same as what i explained above. if you want to do for one of dimension, only way use text boxes to hide.
Thanks,
Nihhal.
for the font size.... no idea....
remove the name. put a space at Label...
to hide the dimension--> Propertied-->Dimension-->Check Enable Condition--> In expression False()
What i said is to hide that entire column
To hide the name what GU sharon said will work
For the font size, you can try on right click on the Dimension -> "Custom Format Cell" ->Test Settings - > Text Size - > 140%
you can't increase a font size of one dimension by default it will be applied to all dimensions
Alternate Solution:
if you are taking about particular Dimension Values then make them BOLD "'<B>'" which will make them differ
if its Dimension Name: then you can use a Text Object placed accordingly on the column.
To hide any Dimension Name you can simply use "<Space>" in dimension Lable name in "Dimension Tab" right bottom
hope this helps you
cheers!!!
hi,
may be you can try Dimension - Custom Format Cell -Test Settings - Text Size -
Hi,
Could you guide me where can i find Custom Format Cell -Test Settings - Text Size - in Dimension Tab.
Thanks
this will work as default too as i mentioned
you need to enable it
Setting --> User Preference--> Design
enable check box "always show design menu items"
then right click any pivot chart and you will see the option "Custom Format Cell "