Multi Line Caption in Straight or Pivot Chart

[#1]

Hi all,

Wrap does not work! How to create multi line caption as below:

=[Branch Name]

='Profit and Loss'

='For the period ended '&Month&' '&Year

thanks in advance!

BR,

SAK

[Gysbert_Wassenaar · Accepted solution]

Try

=[Branch Name] & chr(10) & 'Profit and Loss' & chr(10) and 'For the period ended '&Month&' '&Year

Don't forget to enable the Wrap Text option on the Caption tab of the properties window and set the Caption Height to 3 lines.

[juleshartley]

Have you tried chr(10)

eg.

=[Branch Name] & chr(10) &

'Profit and Loss' & chr(10) &

'For the period ended '&Month&' '&Year

[#4]

But to how to export this caption to excel along with the chart.

[Gysbert_Wassenaar]

That's only possible with a macro. See here for an example.

[#6]

Thanks! so these are ASCII codes

http://www.techonthenet.com/ascii/chart.php

http://www.theasciicode.com.ar/ascii-control-characters/line-feed-ascii-code-10.html