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!
Reply With Quote
Bookmarks