how to set a variable to a Chart? not ChartObject

Sheet1 contains "Chart 1"

I want to set a variable to "Chart 1"

Dim chrt As Chart
Set chrt = Sheets("Sheet1").ChartObjects("Chart 1")

This gives a type mismatch error. If I Dim chrt As ChartObject then I do
not get the chart methods/properties in the dropdown. But I don't see any
other options for setting chrt to "Chart 1". Any suggestions appreciated.

Thanks,
Rich

"Rich" <[email protected]> wrote in message
news:[email protected]...
> I want to set a variable to "Chart 1"
>
> Dim chrt As Chart
> Set chrt = Sheets("Sheet1").ChartObjects("Chart 1")
>
> This gives a type mismatch error. If I Dim chrt As ChartObject then I do
> not get the chart methods/properties in the dropdown. But I don't see any
> other options for setting chrt to "Chart 1". Any suggestions appreciated.

Hi Rich,

This is how to get at the underlying Chart contained in a ChartObject:

Set chrt = Sheets("Sheet1").ChartObjects("Chart 1").Chart

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

Dim chrt As Chart
Set chrt = Sheets("Sheet1").ChartObjects("Chart 1").Chart

--
Regards,
Tom Ogilvy


"Rich" <[email protected]> wrote in message
news:[email protected]...
> Sheet1 contains "Chart 1"
>
> I want to set a variable to "Chart 1"
>
> Dim chrt As Chart
> Set chrt = Sheets("Sheet1").ChartObjects("Chart 1")
>
> This gives a type mismatch error. If I Dim chrt As ChartObject then I do
> not get the chart methods/properties in the dropdown. But I don't see any
> other options for setting chrt to "Chart 1". Any suggestions appreciated.
>
> Thanks,
> Rich

Thanks all for your replies. Really appreciate it.

Rich