Naming and referring to a chart in VBA

Question

I am trying to create charts in excel using VBA . The code is as follows :

Sub testmacro()    
    Dim i As Integer     
    i = Sheets("Data").Range("M2").Value
  Sheets("Email ID").Activate
    Range("A1").Select
    ActiveSheet.Shapes.AddChart.Select
    ActiveChart.ChartType = xlColumnClustered

    If i = 1 Then  
        ActiveChart.SetSourceData Source:=Range("Data!$E$1:$F$3")        
    ActiveChart.SeriesCollection(1).Select
    With Selection.Format.Fill
       .
       .
       .        
    End If     

    If i = 2 Then

   End if

   If i=3 Then  

    End If   

End Sub

Now, I want to be able to perform the actions when i=2 and i=3 on the same chart i created when i=1

However, I am not able to do so.

So can anyone help me how to give a name for the chart i created when i=1 and be able to refer to it whie i=2 and i=3??

Pedro Braz · Accepted Answer · 2015-04-28 18:58:00Z

6

Kira, you can change the chart name by code using:

yourchart.Name = "Name"

Or in the worksheet you can select the chart, go to the Layout Tab and in the right edge there will be a text box saying Chart Name

then you can refer to it in your vba code using

Worksheets("yoursheet").ChartObjects("Name").PropertyYouWant

answered Apr 28, 2015 at 18:58

Pedro Braz

2,4213 gold badges30 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gary's Student · Accepted Answer · 2013-08-23 13:43:31Z

5

Here is a way to assign a name to a chart:

Sub dural()
    Dim ch As Shape
    Range("A1").Select
    ActiveSheet.Shapes.AddChart.Select
    Set ch = ActiveSheet.Shapes(1)
    ch.Name = "First Chart"
End Sub

answered Aug 23, 2013 at 13:43

Gary's Student

96.9k10 gold badges66 silver badges104 bronze badges

1 Comment

b0rg Over a year ago

and could you also include in your answer, how to refer to it in future cases in the vba code? I mean how to call it?

Collectives™ on Stack Overflow

Naming and referring to a chart in VBA

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related