Drill Down Question

[rjacmuto32]

I used the Hui Rollover Technique learned on this website before to change all my numbers on a file based on what I hover over. Also I've used just the radial buttons to change data also. My question expands on that and is this possible in excel 2010. Let's say I don't want to change all my data but only certain cells. Is this example possible?


I have say $1500 in cell B2 and $3400 in cell C2. Is there way to say click cell B2 and I can see a breakout of the $1500 by Country somehow. It would show me say $500 USA, $700 Spain, $300 Italy. Then if I clicked or put mouse in cell B3 it would expand the $3400 to say $1900 China, $500 USA etc.


I want to keep it clean and not show all the countries below the data, only want to drill down/blow out 1 cell if someone wants to see the details for that cell. Is this possible?


Thanks,

--Robert

 

[SirJB7]

Hi, rjacmuto32!


I haven't read Hui's technique, but despite of that I'd say that regarding the click on a cell and see a breakout of its value it can be done with the Worksheet_SelectChange event. Regarding mouse hovering (which is naturally handled by Visual Basic event MouseOn, unavailable in Visual Basic For Applications embedded into Excel) you can give a look to this link:

http://chandoo.org/forums/topic/pointing-mouse-to-show-other-series-data-in-the-chart#post-39264


Just advise if any issue.


Regards!

 

[NARAYANK991]

Hi Robert ,


If the cell B2 has 1500 in it , how can any technique in Excel or any other software show you :


$500 USA, $700 Spain, $300 Italy


Is this breakup ( or breakdown ) a part of the data somewhere in your worksheet , and does B2 have a formula which sums up these 3 amounts ?


Or I have not understood your problem ?


Narayan

 

[bobhc]

Good day rjacmuto32


You can get any break down of any data if you use a pivot table (that is if your version of excel has this feature)