Chart with buttons
 

Hi,

I have a chart in its own tab with 6 buttons that run macros to other areas
of the work book and two drop down boxes that control what metrics are seen
in the chart. My problem and question is that when I change the combo box's
the buttons and boxs all move around slightly, leaving me with a messy
looking chart area.

Is there a way to lock them down to stop them from moving??

Thanks for any help

Andy

Chart with buttons
 

Hi,

Have you set the property 'Do not size with chart' for the controls?

Cheers
Anyd

Andy the yeti wrote:
Hi,

I have a chart in its own tab with 6 buttons that run macros to other areas
of the work book and two drop down boxes that control what metrics are seen
in the chart. My problem and question is that when I change the combo box's
the buttons and boxs all move around slightly, leaving me with a messy
looking chart area.

Is there a way to lock them down to stop them from moving??

Thanks for any help

Andy


--

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

Chart with buttons
 

Yes I had, I think the problem is coming from the fact that I have a data
table at the bottom of the chart and vary lenghth of series names is pushing
things around

"Andy Pope" wrote:

Hi,

Have you set the property 'Do not size with chart' for the controls?

Cheers
Anyd

Andy the yeti wrote:
Hi,

I have a chart in its own tab with 6 buttons that run macros to other areas
of the work book and two drop down boxes that control what metrics are seen
in the chart. My problem and question is that when I change the combo box's
the buttons and boxs all move around slightly, leaving me with a messy
looking chart area.

Is there a way to lock them down to stop them from moving??

Thanks for any help

Andy


--

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

Chart with buttons
 

What happens if you embed a chart object within a chart sheet and place
the controls on the chart sheet instead of the chart object?

Andy the yeti wrote:
Yes I had, I think the problem is coming from the fact that I have a data
table at the bottom of the chart and vary lenghth of series names is pushing
things around

"Andy Pope" wrote:


Hi,

Have you set the property 'Do not size with chart' for the controls?

Cheers
Anyd

Andy the yeti wrote:

Hi,

I have a chart in its own tab with 6 buttons that run macros to other areas
of the work book and two drop down boxes that control what metrics are seen
in the chart. My problem and question is that when I change the combo box's
the buttons and boxs all move around slightly, leaving me with a messy
looking chart area.

Is there a way to lock them down to stop them from moving??

Thanks for any help

Andy


--

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


--

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