Alright, so this seemed like the next logical step for the rollover method:
This one is kinda complicated, I admit. Unfortunately, I didn’t really take the time to clean up the spreadsheet file for others to follow (I don’t really have the time these days). Sorry. But try to take it apart – and ask me questions if you have them.
I’ve canvassed some other folks from the Excel community to see if they would want to do a video tutorial of this – and I think that’s what it would take.
Have fun!
Mapper.xlsm
Jordan Goldmeier is an accomplished data professional with a wealth of experience across various industries. He currently serves as a consultant at Anarchy Data, where he assists businesses in maximizing the capabilities of Excel for financial planning and analysis. Jordan is also an instructor at Full Stack Modeller and a former Adjunct Instructor in Analytics at Wake Forest University. His extensive career has seen him hold positions as the Chief Operations Officer at Excel.TV, Data Science Manager at DataKind, Data Scientist at Dealer Tire and EY, Analytics & Data Vis Developer at The Perduco Group, and Operations Research Analyst at Booz Allen Hamilton. Jordan's background in data analytics and his passion for Excel make him a valuable resource for businesses seeking to improve their data-driven decision-making processes.
Latest posts by Jordan Goldmeier (see all)
- All Excel LOOKUPs Explained - May 26, 2020
- How to: Power Query File From Folder - April 21, 2020
- Oz’s Excel Tip: Keep a Workbook for Random Data in Excel - January 23, 2020
Wow !!! seems like the next logical step to my Budget/forecast file, where I used the shapes for the country, and when double clicked on one of them,checked if there were other shaped selected and unselected it,and highlighted the corresponding info on an adjacent table with Budget and Forecast.but, as you, I don't have the time now to merge both concepts, but definitively will try to !!!
Well feel free to share your work!
Nice work Jordan! Check this one too I tried with X Y Scatter charthttps://www.box.com/s/62f55uq37pbtxip1nbmz
Very cool. I see you've employed a method similar to Robert's of ClearlyAndSimply.com and Professional Excel Development. My method above is a bit harder to implement – were you able to understand it? I think using a chart tab and Chart event as you have above has certain advantages to the method I've written about on my blog. Just out of curiosity – would you ever recommend (or implement yourself) the method I've described on Option Explicit VBA? – or, do you think that it may be somewhat impracticable?Thanks again for sharing! I like your blog a lot.
@Jordan I have seen your method using hyperlink mouse hover effect. I have already shared your interactive map link our my FB pages and groups.I would definitely try it when I have to do any location analysis or where ever it fits in. Its always good to have alternate solutions for a problem or scenario
Hi Jordan,
Great work you’ve got here. Please can you kindly explain how you set this up?
Your response will be highly appreciated.
Regards
Leke
I have been looking at the Mapper.xlm file but cant seem to understand. The Sheet 3 – is that information pre-set? or are they coordinates of the States?