Chart with buttons

[Andy the yeti]

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 box’s 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]

Hi,

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

Cheers
Anyd

 

[Andy the yeti]

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]

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?