Chart title

  • Thread starter Thread starter OO7_neverdie
  • Start date Start date
O

OO7_neverdie

Can someone show me how to insert (using VBA) Chart title after created
a chart

Thank you very much
 
007_neverdie

Something like :

Sub AddTitleToChart()
'
ActiveChart.PlotArea.Select
With ActiveChart
HasTitle = True
ChartTitle.Characters.Text = "the title"
End With
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2010. How to copy chart format to all charts in sheet 2
Alter internal margins of chart title using VBA, Excel 2010 2
programming 33 tabs with 1 chart on each, 9 series lines per chart 1
Centered Overlay Title in VBA 1
Chart Title Reverts Back To Previous Value 3
Apparent Excel 2007 chart HasTitle race condition 5
InputBox to resize all charts of active worksheet 2
Chart Title change with Drop Down Selection 2

Back
Top