Chart Objects

[Bill]

Hello,
I have two charts embedded on a worksheet, that I have named ChartA and
ChartB. How can I tell which chart object has been selected by a user? For
example, if a person selects a point on ChartA, I want to run some code to
format that point.

Thanks.

bill

 

[Andy Pope]

Hi,

How about Activechart.Parent.Name , which should return either ChartA or
ChartB.

Cheers
Andy