Hide captions of dimension/expression in pivot chart

[pennetzdorfer]

Hey,

is there a way to hide dimension/expression captions in a pivot chart? (see yellow marked line in the screenshot)

Thanks for you suggestions!

[#2]

HI Florain,

No direct way that I know of. But a work around would be:

1. Go to View->Designer Grid.
2. Right click on the header cell and select custom format cell.
3. Select background and text color to white.

This wont hide but user can't see

Kiran Rokkam.

[Oleg_Troyansky]

I suppose you could define a transparent color for the totals font - try using "Custom Format Cell" option. You will still se empty cells though... I don't think there is a way to disable them completely...

[#4]

or just introduce one blank in the Properties>Dimensions>Label and repeat the same thing for Expressions>Label

[pennetzdorfer]

Hey,

thanks for your ideas!

White background and text color "removes" the captions, but of course the border still wraps the whole table.

My poor workaround is covering the caption with a white text object. But as I want to set up a rather complex layout containing several of those tables this would become a bit messy. I guess there's no "neat" solution to that problem ...