Moving buttons on a chart

M

Mark

I have set up some macros with buttons on a chart to hide or display certain series on the chart. With too many series visible on the chart it gets messy so I hide some if need be. Now the problem is that I have 6 buttons nicely aligned next to each other at the top of the chart, but each time I click on one it moves fractionally (something to do with the chart redrawing I guess), but eventually all the buttons are out of alignment and overlapping etc. How can I stop the buttons moving aroung. I have selected "Do not size with chart" as a button property

Any ideas?
 
J

Jon Peltier

Mark -

You can group the buttons together. They can still be individually
clicked when grouped, and they might still move, but they will at least
move together.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Move Chart with Text 0
Hide Chart When Row Group Closed 0
Macro to change position of chart labels on line chart 1
Chart series select. 3
Charts used for Reporting ! 2
Chart type for machine timing diagram? 3
Aligning an excel table w/ a cluster column chart x-axis columns 2
Excel Chart auto data highlighting anomaly.... 1

Top