Prev: Message still appears with DisplayAlerts = False & SaveChanges:=Fa
Next: object required
From: Barb Reinhardt on 4 Mar 2010 17:37
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
From: Herbert Seidenberg on 4 Mar 2010 18:41
Excel 2007
Sub TitleFormat()
With Sheets("Data").ChartObjects(1).Chart
.SetElement (msoElementChartTitleAboveChart)
.SetElement (msoElementChartTitleCenteredOverlay)
.ChartTitle.Text = "MyChart"
End With
End Sub
 | 
Pages: 1
Prev: Message still appears with DisplayAlerts = False & SaveChanges:=Fa
Next: object required