Multi-line Column Labels in New Pivot Table Object

[jmcy2408]

Hi,

I’m using the new Pivot Table object to display data and have customised the styling under Chart > Grid > Column Height (in lines) — setting it to two lines so that my column labels can appear on multiple lines.

However, even when I manually break the labels into two lines in the expression (or use CHR(10)), the text still wraps automatically in the visualisation instead of respecting my line breaks.

Is there any workaround for this behaviour?

The main reason I’m using the Pivot Table is to be able to lock scrolling on several dimensions — something that the new Straight Table doesn’t currently support, not even for a single dimension.

Thanks,
John

[HirisH_V7]

Check this.

1 .

=If(Len([YourField]) > 15,
    Left([YourField], 15) & Chr(10) &  Mid([YourField], 16),
    [YourField]
)

2.

=If(Len([YourField]) > 20,
    Replace([YourField], ' ', Chr(10))
    [YourField]
)