Grid Chart X-asis label arrange in two lines

[Anonymous]

Hi all

Good morning.  My Grid Chart's x-axis labels are too long. So I'd like to break these labels in two lines (or wrap text) so that I can show the whole labels.  Does anyone know how to do it?

Cheers

Wallace

[Anonymous · Accepted solution]

Just want to share at the end how this can be done...  Just added a script in Dimension of the chart, then the label (if too long) can be separated into 2 lines. 

=if(len([FieldName])>15,left([FieldName],FindOneOf([FieldName],' ',2)-1)&chr(13)&mid([FieldName],FindOneOf([FieldName],' ',2)+1),[FieldName])