You can use the Sheets
property to return a worksheet, chart, module, or dialog sheet; the Sheets collection contains all of these. The following example activates the sheet named "Chart1" in the active workbook.
Charts embedded in a worksheet are members of the ChartObjects
collection, whereas charts that exist on their own sheets belong to the Charts