Selecting a graph using macro

[Dagwood2005]

Hello,

What is the VBA code for selecting a chart to work on? For instance, the code for selecting a worksheet named "Dashboard" is:

Sheets("Dashboard").Select

What is the code for selecting a particular chart?

Thanks.

[VBA Noob]

Hi,

Best way to learn is use the VBA recorder.

Record selecting the chart and see what code it produces

VBA Noob

[Dagwood2005]

i've tried that an i have the code for it---but i need to refer to a specific graph every time I run a macro. the line of code i have written will not let me refer to the name of the chart every time i run the macro.

[antoka05]

You cna also use this code:

ActiveSheet.ChartObjects("Chart1").Activate
or
ActiveSheet.ChartObjects(1).Activate

Regards,
Antonio

[VBA Noob]

Try

Sheets("dashboard").ChartObjects("Chart 2").Activate

Change chart 2 to your chart name

VBA Noob