• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

ZOOM IN ON MICRO PIVOT CHARTS

S

sgordon

New Member
Hello, I created micro pivot charts on a dashboard and want for the viewer to hoover with their mouse over the chart and the chart will appear bigger for viewing. I want this to be automatic and do not want to use the "Zoom to Selection" feature in the View tab because of the clicks you have to do to get back to the other data. I do not know VBA. Is this possible?
 
Good day sgordon


I do not think you can get a hover/mouse action. I had asked about this for some thing similar when mouse hovers over an Excel cell, informed by SirJB7 that unlike Access, Excel does not support this.

You may find this Dashboard manual of use.


https://dl.dropbox.com/u/75495784/dbmanual.doc
 
@b(ut)ob(ut)hc

Hi!

That's true, thanks for the quote.


But as matter of fact and regarding VBA events both Excel and Access "share" the same basic features: none of them support events of mouse moving except in user forms or forms respectively.


Neither Excel handle events for mouse moving on cells nor Access for navigating thru tables or queries. But both do in forms. What might lead to a kind of confusion is that Excel handles events for cell changing and cell selection changing.


Regards!


PS: BTW, nice doc :)
 
Maybe this will help you in what you are looking for:

http://www.2shared.com/file/bKfrFeuh/Chart_Zoom_Example.html

nt8w1.png



*my apologies if this reply shows up twice
 
Good evening Trader273


I like your work and have saved it , you never know when it could come in handy, as there is no hover over with mouse this could be the answer
 
Best I could come up with. Still getting through the VBA classes to get much better at VBA, but at least it's start.
 
Hi, Trader273!


I've been working since early in the morning, so adding to my usual dumbness I think I'm a little tired, but...

What does that your workbook does? I read the steps, but I still don't get it.

If it just resizes chart, why not adding a scroll bar and ¡I just guess how! a command button?


Give a look at this file:

https://dl.dropbox.com/u/60558749/ZOOM%20IN%20ON%20MICRO%20PIVOT%20CHARTS%20%28for%20sgordon%20at%20chandoo.org%29.xlsm


Regards!
 
Always interested to see how other people do things in Excel. I think that's the great thing about xl, is that there are so many ways to accomplish it. I like what you have here, so always something new to look at.


What I have done was just assign the macro to the actual picture of the chart. Just click the chart to zoom in and click it to go back to how it was. Kind of like what a thumbnail would do. When building dashboards I like to minimize the amount of buttons and things like that in order to make it as clean as possible. So if I can just have a macro tied to a chart then it will accomplish what I set out the easiest way.
 
@Trader273

Hi!

Thank you very much, I now got it :$

The damned trick was to click on the chart of the right... how did I didn't see it before? No, thank you, I don't want any answer for that question :p

Regards!
 
Here is a technique from Jordon, using dynamic hyperlinks


http://www.keepandshare.com/doc/2999602/cameraobjectwhyperlink-xlsm-july-21-2011-11-25-pm-23k


See this for more: http://chandoo.org/wp/2011/07/20/interactive-dashboard-using-hyperlinks/
 
And one more attempt, without VBA. Not so elegant but you can definitely fine tune it.


http://img.chandoo.org/playground/zoom-using-scroll-bars.xlsx
 
You must log in or register to reply here.
Back
Top