#1   Report Post  
Posted to microsoft.public.excel.charting
Andy the yeti
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.charting
Andy the yeti
 
Posts: n/a
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
Putting Command Buttons on a Chart Sheet Kremlin Charts and Charting in Excel 2 May 11th 05 01:06 PM
Urgent Chart Assistance Brent E Charts and Charting in Excel 1 May 10th 05 09:09 AM
Urgent Chart Questions Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM
Urgent Chart Assistance Requested Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM


All times are GMT +1. The time now is 07:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"