Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
For example I want to produce one output like this
Housekeeping
a)xxxxxxxxxxxxxxx
b)yyyyyyyyyyyyyyy
I tried to use Chr(10)
='Housekeeping' & Chr(10) & ' a) xxxxxxxxxxxxxx' & Chr(10) & 'b) yyyyyyyyyyyyy'
but it did not work
Any ideas??
Thank you in advance!
Try this.
='Housekeeping' & Chr(10) & Chr(13) & ' a) xxxxxxxxxxxxxx' & Chr(10) & Chr(13) & 'b) yyyyyyyyyyyyy'
Above expression works perfectly with Chr(10).. I tried in text object
Hi Nagesh,
Below is my input and output
input:
output :
Any ideas? Thank you!
Try this.
='Housekeeping' & Chr(10) & Chr(13) & ' a) xxxxxxxxxxxxxx' & Chr(10) & Chr(13) & 'b) yyyyyyyyyyyyy'
Hi Nagesh, if i mouse over the label, it looks like it worked. Thanks. i just need to find a way to increase the height of the label. thanks
Hi,
I am also facing the same Issue on adding line break on my KPI lable as it is long description.
="'Hi'&Chr(10)&Chr(13)&'Hello'"
Its not breaking line but its showing next line when I mouse hover.
Appreciate the solution.
Thanks,
Ditto
It doesn't work in the visualization, only when you hover over with the mouse.
Any other suggestions?
Thanks