Hi,

If you use Form controls rather than ActiveX controls then you can place
them on a chart sheet or within an embedded chart object.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Dave" wrote in message
...
Hi Andy

Unfortunately, this is of no use. I need to be able to place the drop down
in the actual chart sheet

Thanks

"Andy Pope" wrote:

Hi,

Maybe this will help.
http://peltiertech.com/Excel/Charts/ChartByControl.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Dave" wrote in message
...
Hi,

Is it possible to add a drop down menu into a chart which can link to
the
data I am using.

Thanks