Results 1 to 4 of 4

Thread: Drag And Zoom Chart Zoomer Add-In

  1. #1
    Junior Member
    Join Date
    Oct 2012
    Posts
    3
    Rep Power
    0

    Drag And Zoom Chart Zoomer Add-In

    I know this is a bit old but hopefully this helps someone out. I created this addin 4 years ago that uses a rectangle shape that the user can drag over a chart and it would zoom in on the area. It works for XYscatter type charts and works on any number of series. You can zoom in as much as you want and unzoom all the way back to the initial level. Also has an autofit button. I developed it for Excel 2003 and in 2003 and 2000 it creates icons on the right click subcontext menu but in 2007 and above that was taken out. I also had it create its own toolbar but that was also taken out in 2007 and up. In those versions, the icons are on the add-ins tab on the ribbon when you select a chart. It is somewhat glitchy in 2007 but it still works for me ok and seems to work better in 2010.

    https://docs.google.com/open?id=0B47...UlkaWhMOWFRUlk - 2003 version
    https://docs.google.com/open?id=0B47...Gw3WE9PWkZmU3M - 2007 and up version

    If anyone has any suggestions let me know. And feel free to mod the code to fit your needs just give me credit if you distribute it.

    Let me know what you think!
    Attached Files Attached Files

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Jason, this is really good. Would be nice to have someone mod this and have it work for a few other commonly used charts also. But nicely done this one, and thanks for sharing.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Junior Member
    Join Date
    Oct 2012
    Posts
    3
    Rep Power
    0
    Quote Originally Posted by Excel Fox View Post
    Jason, this is really good. Would be nice to have someone mod this and have it work for a few other commonly used charts also. But nicely done this one, and thanks for sharing.
    Thanks Excel Fox! I just recently upgraded to Excel 2007 so I haven't been able to test much in the newer versions. I have 2010 and 2007 at work now so I've been messing with the code a bit. I already found a glitch in 2007 when using on dual Y axis charts. Here's the fixed version.
    Attached Files Attached Files

  4. #4
    Junior Member
    Join Date
    Mar 2013
    Posts
    2
    Rep Power
    0

    Great

    Just a comment
    I have realized that, once you zoom-inn a chart, the axis number formatting is changed.
    I use a no-decimal format in the original chart and a 3 decimal format appears in the zoomed area.
    Any suggestions?
    Thank you for your great job
    Juan

Similar Threads

  1. Chart Zoomer (Resizer)
    By Admin in forum Download Center
    Replies: 14
    Last Post: 12-14-2020, 06:11 AM
  2. Excel Chart Showing Values on Angle: Nightingale Chart
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 0
    Last Post: 10-17-2012, 06:39 PM
  3. Replies: 1
    Last Post: 05-20-2012, 12:23 PM
  4. Chart zoomer by Kris
    By Rasm in forum Excel Help
    Replies: 2
    Last Post: 07-06-2011, 10:24 PM
  5. Krishnarkumar's Chart Zoomer
    By Jim Fleming in forum Excel Help
    Replies: 0
    Last Post: 04-03-2011, 09:04 PM

Tags for this Thread

Posting Permissions

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