VBA for Excel 2007 tutorial-title of the chart


Title of the chart

In this VBA code example, you will learn to set title text of your chart. To set title text of a chart you can specify the the HasTitle property of ActiveChart object to True and use the ChartTitle to specify the title caption.



VBA for Excel: VBA example code to set title text of the chart

To run this VBA example code, you can copy and paste the VBA code below in to the block of Worksheet_Activate() procedure. To open this block, double-click the current worksheet, then in the objects dropdown list select Sheet1 and in events list select Activate.



VBA code for this example:

 

Option Explicit

Private Sub Worksheet_Activate()

    Dim i As Integer

    'Fill Source data

    For i = 1 To 10

        Randomize

         Range("A" & i) = Int(100 * Rnd) + 1

         Range("B" & i) = Int(100 * Rnd) + 1

    Next

 

    'Select the data source

    Range("A1:B10").Select

    'Create a clusted column chart

    ActiveSheet.Shapes.AddChart xl3DColumn, 200, 100

    ActiveSheet.Shapes(1).Select

    ActiveChart.SetSourceData Source:=Range("Sheet1!$A$1:$B$10"), PlotBy:=xlColumns

    ActiveChart.HasTitle = True

    ActiveChart.ChartTitle.Caption = "A simple chart"

End Sub



Comments





This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.