Jan 15 2021 06:17 PM
I have a table of geographic topography divided into regions. I would like to add a link to click on a specific region, than add it to the map function. How do i do this?
\
Jan 16 2021 03:59 AM
Create a Map chart in Excel
Hope I could help you at least a little.
I would be happy to know if I could help.
I wish you continued success with Excel
Nikolino
I know I don't know anything (Socrates)
Jan 16 2021 05:49 AM
very interesting. You've just given me hope I might find a way of doing a similar thing for a clickable map of the human body.
I posted it on another thread the other day, but as yet no responses.
https://techcommunity.microsoft.com/t5/excel/how-do-i-put-multiple-clickable-cells-on-top-of-an-imag...
Jan 16 2021 09:26 AM
How to create a heatmap (area map) in Excel (The site is in Swiss - German)
https://excelnova.org/wie-man-eine-heat-map-flachenkartogramm-in-excel-erstellt/
Not sure if I got it right. But think that you might be looking for something like that in this direction. Anyway, maybe that will bring you closer to your goal.
I wish you continued success with Excel
Nikolino
I know I don't know anything (Socrates)
Jan 16 2021 05:33 PM
yeah that was the sort of thing I was thinking of, but its colours are changed by values in a table, I just want to be able to click.
I've found some VBA code to change the colour of a shape when I click it, but it only toggles it off, not on.
Jan 17 2021 04:04 AM
Jan 17 2021 06:23 AM
Much appreciated as I'm new to all this!
My last reply was truncated for some reason :( I've actually had some success and someone's put me on the right track, but still having a few hiccups, I started a new thread on the subject if you're into taking a look...?
All the best and thanks again :)