LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default Chart Zooming and scrolling

Put the chart into a blank worksheet, and constrain the ScrollArea to the
cells covered by the chart. Then you can use the ScrollRows and
ScrollColumns, or the LargeScroll and smallscroll to move around.

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


wrote in message
ups.com...
Please shoot me or somehow put me out of my misery!

Try the following:
(1) Create a dummy scatter chartsheet manually. Data is not important,
chart can be completely blank for this test.
(2) Zoom-in with 200 magnification on the chart.
(3) Now WRITE a VBA macro to position the view to the upper right
corner of the chart.

Scrollbars movement don't seem to be functional within VBA at least on
chart pages.

Thanks in advance
Ken



 
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



All times are GMT +1. The time now is 04:36 AM.

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

About Us

"It's about Microsoft Excel"