Chart with buttons

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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?
 
Back
Top