X-axis wrap test

[nareshthavidishetty]

Hi,

I have wrapped the text in x-axis by using the below code.But still i need the 'corpus christi and the valley' required more wrap.

Below is the image and code used to wrap the text.

Code:

=if(SubStringCount(trim(District_Desp),' ')<=6,

  SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',1)

  &' '&SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',2)

  &chr(13)&SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',3)

  &' '&SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',4)

  &chr(13)&SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',5)

  &' '&SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',6)

  &chr(13)&SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',7))

Thanks..

[sunny_talwar · Accepted solution]

May be this:

=if(SubStringCount(trim(District_Desp),' ')<=6,

  SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',1)

  &chr(13)&SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',2)

  &chr(13)&SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',3)

  &chr(13)&SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',4)

  &chr(13)&SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',5)

  &chr(13)&SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',6)

  &chr(13)&SubField(replace(replace(replace(trim(District_Desp),' -- ','-'),' - ','-'),' (','('),' ',7))

[nareshthavidishetty]

Hi Sunny,

Thanks a lot.

Pivot table column shift

[sunny_talwar]

Pivot table column shifts? Not sure what you mean?

[nareshthavidishetty]

please check in community it's an request.