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?
--
CroceJC

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

Regards,
Peter T


"jc" wrote in message
...
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?
--
CroceJC

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

On 18/03/2010 14:59, jc wrote:
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?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info