Results 1 to 4 of 4

Thread: Drag And Zoom Chart Zoomer Add-In

Threaded View

Previous Post Previous Post   Next Post Next Post
  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!

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://eileenslounge.com/viewtopic.php?p=320960#p320960
    https://eileenslounge.com/viewtopic.php?p=320957#p3209573
    https://eileenslounge.com/viewtopic.php?p=318868#p318868
    https://eileenslounge.com/viewtopic.php?p=318311#p318311
    https://eileenslounge.com/viewtopic.php?p=318302#p318302
    https://eileenslounge.com/viewtopic.php?p=317704#p317704
    https://eileenslounge.com/viewtopic.php?p=317704#p317704
    https://eileenslounge.com/viewtopic.php?p=317857#p317857
    https://eileenslounge.com/viewtopic.php?p=317541#p317541
    https://eileenslounge.com/viewtopic.php?p=317520#p317520
    https://eileenslounge.com/viewtopic.php?p=317510#p317510
    https://eileenslounge.com/viewtopic.php?p=317547#p317547
    https://eileenslounge.com/viewtopic.php?p=317573#p317573
    https://eileenslounge.com/viewtopic.php?p=317574#p317574
    https://eileenslounge.com/viewtopic.php?p=317582#p317582
    https://eileenslounge.com/viewtopic.php?p=317583#p317583
    https://eileenslounge.com/viewtopic.php?p=317605#p317605
    https://eileenslounge.com/viewtopic.php?p=316935#p316935
    https://eileenslounge.com/viewtopic.php?p=317030#p317030
    https://eileenslounge.com/viewtopic.php?p=317030#p317030
    https://eileenslounge.com/viewtopic.php?p=317014#p317014
    https://eileenslounge.com/viewtopic.php?p=316940#p316940
    https://eileenslounge.com/viewtopic.php?p=316927#p316927
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Attached Files Attached Files
    Last edited by DocAElstein; 10-04-2024 at 10:25 PM.

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
  •