Programable Controls on a Chart

[jc]

I've got a simple chart in Excel 2003 that I want to add controls to that
progrmaticaly chage the data the chart referes to when the user manipulates
the control. When I open a control toolbox, the controls are greyed out when
the chart is active. When I then select a worksheet the controls are then
available (Not greyed out).

Is there a setting to make controls available on a chart or is this not
possible?

 

[Peter T]

You can't embed ActiveX controls in a chart, however the Forms controls will
typically work fine for most needs.

Regards,
Peter T

 

[Andy Pope]

Hi,

If you are trying to place controls within a chartobject or directly on
a chart sheet you will need to use the older Forms toolbar controls
rather than the ActiveX control toolbox variety.

Cheers
Andy