name of a chart object

Hi yellowpower,
I think this one is from Tom Schreiner

Please Login or Register  to view this content.

hope it helps

Hello,

you can also give your charts meaningful names instead of the default name Excel assigns. Click outside of the chart, then hold down the Ctrl key and click the chart. Now you see "Chart 1" (or similar) in the Name Box above cell A1. Change the name in the Name Box to something more meaningful and you can refer to the chart by that name in code.

For example, if you Ctrl-click the chart and give it the name ABChart, you can then refer to it with

Please Login or Register  to view this content.

cheers