Hi again Charles,

Just a little added info. In lieu of activating the chart and then setting a
variable to the active chart you can use the following line of code and there
is no need to activate the chart.

Set myChrt = ActiveSheet.ChartObjects("Chart 3").Chart

or

Set myChrt = Sheets("Sheet1").ChartObjects("Chart 3").Chart


If you don't know the name of the chart.
Select any cell on the worksheet (to deactivate the chart)
Turn on the macro recorder.
Select the chart.
Turn off the macro recorder
You should have a recorde line of code like the following.

ActiveSheet.ChartObjects("Chart 3").Activate

--
Regards,

OssieMac