Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do you edit the label formatting on a pivot table chart, specifically "pajama blue". All of the labels are bolded except for my expression label. Is there a way to bold this label?
Enabling the grid is done by choosing the Design Grid option in the View menu. You can also enable the Custom Format option by enabling the option Always Show Design Menu Items on the Design tab of the User Preferences window.
Enable the grid and then right click the header of the expression and choose Custom Format. Then change the format to what you need.
when i right click on the expression header, this is what i see (image). I am not 100% sure what enable the grid but i was assuming just making it active by clicking on it?
Enabling the grid is done by choosing the Design Grid option in the View menu. You can also enable the Custom Format option by enabling the option Always Show Design Menu Items on the Design tab of the User Preferences window.
i enabled the grid but i still get the same right click options. I am running v11.20, would that make a difference?
v11.20 is not the problem. I have no idea what you're doing or not doing that's causing the Custom Format Cell option not to show up. Have you tried changing the User Preferences?
my mistake, i was overlooking the option for Custom Format Cell. Thanks for your help
Pivot table sounds familiar, the thing in Excel? Seems to be like a pivot grid control. Moreover, I conceive that something like a UI label may also bring convenience to this problem.