Results 1 to 3 of 3
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Zoom and Pan Charts (Excel 2000)

    We are indebted to SammyB for <post#=142,006>post 142,006</post#>.
    I decided I wanted to be able to zoom in and zoom out, and pan left and right on a chart.
    The attached zip file contains the plagiarized BAS modules which achieve my goal.
    The Download is too big to attach at 118KB, but it contains the VBA code AND a sample chart and toolbar with which you can play instantly.
    I'm not bragging about the code - it is more proof-of-concept than anything, and I can think of things I'd like to do, such as
    (1) Check for exceeding the data limits to left and right
    (2) Zoom/pan on an axis other than the x-axis
    Attached Files Attached Files

  2. #2
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Zoom and Pan Charts (Excel 2000)

    >> and I can think of things I'd like to do, such as

    And I can see immediate uses for this little gem. <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15> Thank You Chris <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>
    Regards
    Don

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Zoom and Pan Charts (Excel 2000)

    >Thank You Chris
    Don, You're welcome, but it's Sammy B you should be thanking.
    I spent roughly a million hours (<post:=716,324>post 716,324</post:>) struggling with Data Series, Ranges, Cell Counts, eye of newt etc. until I caught Sammy's "scale" post (<post:=142,006>post 142,006</post:>).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •