+ Reply to Thread
Results 1 to 2 of 2

'Dynamic' image feasibility question

  1. #1
    Registered User
    Join Date
    06-11-2006
    Posts
    15

    'Dynamic' image feasibility question

    Hi all,

    I am not sure how feasible my plans are, but if they are if someone could point me in the right direction it would be much appreciated.

    What I'm looking at doing is having a dynamic image (lets say a map) where if someone clicks / rolls mouse over a specific area (within a specific countries borders) data comes up about that country (for example, a companies performance within that country, or stats about that countries population, etc.).

    How feasible is this? What I'd ideally like is to be able to do this but have the data that is shown as a lookup field, with one sheet sourcing data from the company database and then a macro / vlookup to find the information relevant to that country, to make the file remain live.

    One hiccup I thought could occur is the mouseover, but what I thought I could do is (as I have photoshop) take the map, and make each country a seperate image, so then I could have the mouseover/click code based on the individual image of that country.

    I hope this is fully explained, and any help is much appreciated, thanks.

  2. #2
    Valued Forum Contributor
    Join Date
    10-17-2010
    Location
    Nottingham, England
    MS-Off Ver
    Excel 2003, 2007, 2010, 2013, 2016, 2019, 365
    Posts
    294

    Re: 'Dynamic' image feasibility question

    You haven't told us what version of Excel you're using.
    In 2007, insert the image of the country, right-click on it > Assign Macro > Record, give it a sensible name, then select cell A1 and type in the name of the country, then hit 'enter'. On the Developer tab, 'Stop Recording'.
    Only difference for 2003 is to use the 'Stop Recording' button on the macro toolbar.

    Do that for each country, and you've created a map on which, if you click, it fills in the input cell A1 for you. You can then write all your formulae on the sheet to extract data for that country.

    Would be a good idea to put data validation on the input cell, to make sure valid values are typed, if that's how they choose to do it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1