Toolbox is dimmed

I need to add and format few controls to a chart (assign a color and/or a
macro to each of them). When I select View Toolbox, it pops up, but all
controls are dimmed. I can switch to Design Mode in and out, but in both
cases controls are dimmed and I can not select it... (I need checkbox,
textbox and label)

Related question: How do I group them together in a rectangular agea when I
finally learn how to put them on the chart?

I use two types of charts - radar and bar chart - hope that is irrelevant...

thanks you

Hi,

The toolbox is dimmed because ActiveX controls, those from the Control
Toolbox toolbar, can not be embedded within a chart or chart object.
If you want controls within a chart you will need to use the Forms Control
toolbar.

The frame control could be use to place a border around all the controls.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Naum" <Naum@discussions.microsoft.com> wrote in message
news:130033B9-3A0F-4DBE-801D-1C43E33C2C3C@microsoft.com...
>I need to add and format few controls to a chart (assign a color and/or a
> macro to each of them). When I select View Toolbox, it pops up, but all
> controls are dimmed. I can switch to Design Mode in and out, but in both
> cases controls are dimmed and I can not select it... (I need checkbox,
> textbox and label)
>
> Related question: How do I group them together in a rectangular agea when
> I
> finally learn how to put them on the chart?
>
> I use two types of charts - radar and bar chart - hope that is
> irrelevant...
>
> thanks you
>