Excel help

[jessclair2007]

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?

\

[#2]

@jessclair2007 

Create a Map chart in Excel

https://support.microsoft.com/en-us/office/create-a-map-chart-in-excel-f2cfed55-d622-42cd-8ec9-ec8a3...

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)

[#3]

@NikolinoDE 

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...

[#4]

@nic-nicol 

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)

[#5]

@NikolinoDE 

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.

[#6]

I am happy that I can contribute to your goal.

I wish you a nice day and continued success with Excel

Nikolino
I know I don't know anything (Socrates)

[#7]

@NikolinoDE 

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 :)

https://techcommunity.microsoft.com/t5/excel/trying-to-toggle-colour-of-shapes-on-mouse-click/m-p/20...