Programable Controls on a Chart

  • Thread starter Thread starter jc
  • Start date Start date
J

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?
 
You can't embed ActiveX controls in a chart, however the Forms controls will
typically work fine for most needs.

Regards,
Peter T
 
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
 
Back
Top