Managing a MS Excel Chart using VB

[shimotojr]

Good day,
Thank you for allowing me to be a member of this page or group.
Want to ask how can I assign a name of a chart using VB codes.

I'm only a newbie in MSExcel VB codes.

Hope you can help me guys.


Thank you in advance.

shimotojr

 

[NdNoviceHlp]

Hi shimotojr and Welcome to the Board! Not quite clear if U want to refer to a chart or name a chart? Anyways, there are 2 types of charts. Charts embedded on a sheet and charts that are their own sheet. To reference either generically you can use...

ActiveChart

To reference embedded charts...

Sheets("Sheet1").ChartObjects(1)' 1 is the chart index
Sheets("Sheet1").ChartObjects("ChartName")

To reference a chart sheet...

Sheets("ChartName")'

To name a chart I think U can just do something like this...

Sheets("Sheet1").ChartObjects(1).Name = "YourChartName"

Google either Jon Peltier of Tushar Mehta for exact chart knowledge. HTH. Dave