If you want suggestions on your existing code, you should post it.
How about changing the window zoom instead of messing with the chart?
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"
m wrote in message
...
I want to be able to create a button that will automatically enlarge a
graph,
and then when it is pushed again will shrink the graph back to its
original
size. I tried doing this and the graph kept shifting to the left every
time
I pressed the button. I do not want the graph to move, only to resize.
Thanks
Adam Bush