Thread: Centered Overlay Title in VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default Centered Overlay Title in VBA
Excel 2007
Sub TitleFormat()
With Sheets("Data").ChartObjects(1).Chart
.SetElement (msoElementChartTitleAboveChart)
.SetElement (msoElementChartTitleCenteredOverlay)
.ChartTitle.Text = "MyChart"
End With
End Sub
Reply With QuoteReply With Quote