Multiple line chart title

Anything VBScript-related, including Windows Script Host, WMI, ADSI, and more.
Forum rules
Do not post any licensing information in this forum.

Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
Locked
User avatar
rdemaat
Posts: 9
Joined: Wed Apr 28, 2010 5:05 am

Multiple line chart title

Post by rdemaat » Mon Jan 30, 2012 7:12 am

I have a script that is creating an excel chart. But I want to be a little picky about the title. I want 3 lines. Each one having a different font and size.

Chart Title Line1
Chart Title Line2
Chart Title Line3

Anyone know how to do this? Right now I just have a really long title using one .charttitle.text command.

objChart.ChartTitle.Text = "Chart Title Line1"

Thanks!

User avatar
jvierra
Posts: 13507
Joined: Tue May 22, 2007 9:57 am
Contact:

Multiple line chart title

Post by jvierra » Mon Jan 30, 2012 7:49 am

You can only have one 'ChartTitle'. It is a property of the 'chart' object.

http://technet.microsoft.com/en-us/libr ... 92892.aspx

http://msdn.microsoft.com/en-us/library ... e.11).aspx

User avatar
rdemaat
Posts: 9
Joined: Wed Apr 28, 2010 5:05 am

Multiple line chart title

Post by rdemaat » Mon Jan 30, 2012 8:08 am

Ok. Thank you!

Locked