Centered Overlay Title in VBA

's Computer Specifications

I'd like to ensure that the titles of my chart are all set to be "Centered
Overlay Title", but I can't figure out the code to do it. I've got the chart
object named myCht. What next?

Thanks,
Barb Reinhardt

's Computer Specifications

Excel 2007
Sub TitleFormat()
With Sheets("Data").ChartObjects(1).Chart
.SetElement (msoElementChartTitleAboveChart)
.SetElement (msoElementChartTitleCenteredOverlay)
.ChartTitle.Text = "MyChart"
End With
End Sub

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Title overlay	=?Utf-8?B?Smlt?=	Windows XP MovieMaker	2	6th Nov 2006 02:19 AM
RE: Help with XML Title overlay	=?Utf-8?B?ZGlja21y?=	Windows XP MovieMaker	3	11th Mar 2006 05:01 PM
centered title w/ solid lines	=?Utf-8?B?c3JzMTAx?=	Microsoft Word Document Management	1	28th Feb 2005 10:21 PM
centered title w/ solid lines	=?Utf-8?B?c3JzMTAx?=	Microsoft Word Document Management	2	28th Feb 2005 08:51 PM
Centered title keeps goin back to left justified.	=?Utf-8?B?S2FyZW4=?=	Microsoft Powerpoint	3	2nd Dec 2004 03:45 AM