Watching the News This Evening…
… I saw the weather man start from a view way out, click and drag a square on the map, and drill down to our viewing area. Just like he always does.
Tonight however I had the thought – “Wow, that would be a cool feature for an Excel chart”. I’m not sure if the same implementation would be preferable, possibly the drill down area could enlarge in a pop-up window? Possibly a Zoom for a chart object and not the entire sheet?
Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
Get answers right away at our AE Excel Support Forums!
Mark -
I worked on something like this a few years back. I had a pretty good prototype, then I left that job and moved on to other things. I suppose I could be tempted to revisit the project….
- Jon
Jon, Could you share the code on how you did this? I would love to see how you did it.
It’s huge, and flaky, unlikely to be documented, probbly pretty amateurish, and I haven’t looked at it in years. I’d want to give it a once-over before letting it out of the box. It’s on one of the CDs in that box.
Basically, I had a button that enabled chart events. The first click started drawing a rectangle (autoshape), and the drag sized it. Then the user could adjust the size of the rectangle, and click a button to change the axes to match the rectangle. For an XY chart it’s pretty straightforward. For other types with category axes, it took lots of kludges to make adjustments, and I never came up with a satisfactory way to save the chart’s settings that wouldn’t break if the file were emailed around or the chart moved to another sheet. I have had some ideas in the intervening time, which have worked out in other applications.
Maybe one of these days I’ll take a peek at the project. Stay tuned.