Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have added a text in a line chart-properties-presentation-Add text
There i have added "concat(Product,', ')", so the values are coming but not all are displayed as i can't stretch the text box too much.
So is there any way to make the values display in the next line so that all values can be shown and also to have a vertical or horizontal scroll-bar in it??
PLEASE HELP.
Thanks in advance.
In presentation check the multiline settings ( wrap header text).
Else try giving carriage return between text like 'text 1'&chr(13)&'text 2'
That is for list box and multi box but i want it for text box inside the chart.
If you add Text in 'Text in Chart' option you won't get the scroll bar.
There is one work around for this .
Take one text box and add your expression in it and check the Horizontal scroll bar option.
So it will give horizontal scroll if there r multiple values.
Hope this will help you..!
You can use a newline character as your delimiter.
concat(DISTINCT Product,chr(10))
That will place each product on a new line, and you may be able to size the text box to fit (Press Ctrtl-Shift while in the chart and drag the box size). There is no way I know of to get a scroll bar.
As an alternative, you may want to put the expression in a Text Object and place that on top of the chart.
-Rob
I don't think you can add a scroll bar to the text in chart, but I've used the 'carriage return' code before to move text to the line below when it is too long. For example:
='Text line 1'
& chr(13) & chr(10)
&'Text line 2'
Yeah, I can do that but i have to export chart along with the text.
So, if i take another object i can't export both altogether. So I have to go for it.