How to format title of the Chart Object??

[priyav24]

Hello Everybody,

                          I have a requirement  that i want to show the title of the chart in two lines...that is i need to wrap the title of the chart object in two lines,there is no caption for this chart object.I want to make changes to the title of the chart object.

Note: There should not be a caption for the chart object.

Thanks in Advance,

Priya

[kaushiknsolanki · Accepted solution]

HI,

     Try this.

     ='This chart is about ' & chr(10) & ' Sales '

     Use the chr(10) to get an extra line.

     Dont forget to use the multiline option in caption tab.

Regards,

Kaushik Solanki