Vertical Text on Column sizing issue

[#1]

Hi,

Having some trouble with the formatting of a pivot table, please see attached for screenshots of the issue i'm having.

The problem i'm having is that the sizing of a the vertical text on column header is too long!

In the options i have seleceted --> Presentation - vertical text on columns tick box. There is only one expression in the table and that is an if statement that either shows 1, or if there is a booking it will show information about that booking by way of concatenating a number of dimensions together. The reason i do that is it means when a user hovers over it will display this useful information.

The problem I'm having is that for every extra dimension i concatenate it make the vertical text column longer and as a result as you can see in the screenshot it make the table unusable.

Do you have any idea how i can either just resize this column, or if there is another solution to this problem.

Thanks

[veidlburkhard]

Hi Hemant,

Go on 'Chart Properties', 'Presentation' tab there you'll find the 'Multiline Settings'. Please tick the 'Wrap header text' check box and enter 2 or 3 or whatever you want to have a number of lines for your header text. See example below:

Hope this helps.

Regards

Burkhard

[#3]

Hi Burkhard,

Thanks for the suggestion. That does work but ideally was wanting a way to keep the label vertical. The option you've suggested means the formatting doesn't look quite right as i have to widen the columns a touch, and the text displays as follows:

6:

00

p

m

[sunilkumarqv]

Hi Hemant ,

Changes the Fit to Columns to Data and Equal Column width -right click on chart

[#5]

Hi Sunil,

Afraid this ends up with the opposite effect of having not only very tall headers but also very wide ones!

If you look at my attachment its important that the expression cells retain a small square shape as its just the colour of the cell that is important.

thanks

Hem

[veidlburkhard]

Any chance, Hemant, to shorten your long text. I mean you can cut 'JOB ID '. May be you can create a short version for the header of this your pivot table...

Only to think about

Burkhard

[sunilkumarqv]

Can you attached sample one

[lawrenceiow · Accepted solution]

Hemant Patel, I don't know if you're still needing an answer to this as your post is old. But, just in case. I had the same issue with a stupidly tall vertical column header row. I posted my issue after searching the community and not finding the answer, I did come across yours though.

I was provided an answer by the legend known as Gysbert Wassenaar, it turns out the issue was that I had not provided a label for the expression and so the height of the box became the length of the expression formula. I set the label to =' ' (single space) and this cured the problem.

[Anonymous]

Thanks Lawrence, this was a great tip (especially because it's something so unintuitive...i never would have guessed it on my own)

[lawrenceiow]

Glad this worked for you Aaron. I've been finding a number of things that seem unintuitive. I think that's where this community becomes really helpful.