Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])
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])