Label in Pivot table

[#1]

Hi All,

I need a help from you. Please look at the attached image. I need to show the "Month to date variance to budget in 3 lines" What is the ASCII characters for New line.

Thanks,

Raghu.

[#2 · Accepted solution]

Hi Raghu

Try

='Month' & chr(13) & 'To' & chr(13) & 'Date'

[#3]

Thanks Nigel

[#4]

Nigel,

The words are coming in the next line when we use chr(13) but in the pivot table whole thing i cant see. when we move the mouse then only it is visible. How can i make it fully visible.

-Raghu.

[#5]

Nigel,

The words are coming in the next line when we use chr(13) but in the pivot table whole thing i cant see. when we move the mouse then only it is visible. How can i make it fully visible.

Without moving the mouse i can see the complete thing. How can i do that?

-Raghu.

[#6]

Hi Raghu

You need to set the height of the heading bar to 3 lines, do this in the Presentation tab of the properties of the pivot.

Cheers,

[#7]

Thanks Nigel,

Its working

-Raghu.