Excel help

%3CLINGO-SUB%20id%3D%22lingo-sub-2066270%22%20slang%3D%22en-US%22%3EExcel%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2066270%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20table%20of%20geographic%20topography%20divided%20into%20regions.%20I%20would%20like%20to%20add%20a%20link%20to%20click%20on%20a%20specific%20region%2C%20than%20add%20it%20to%20the%20map%20function.%20How%20do%20i%20do%20this%3F%3C%2FP%3E%3CP%3E%5C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2066270%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2066878%22%20slang%3D%22de-DE%22%3ESubject%3A%20Excel%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2066878%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F931208%22%20target%3D%22_blank%22%3E%40jessclair2007%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECreate%20a%20Map%20chart%20in%20Excel%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-a-map-chart-in-excel-f2cfed55-d622-42cd-8ec9-ec8a358b593b%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-a-map-chart-in-excel-f2cfed55-d622-42cd-8ec9-ec8a358b593b%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20could%20help%20you%20at%20least%20a%20little.%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wish%20you%20continued%20success%20with%20Excel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2067038%22%20slang%3D%22en-US%22%3EBetreff%3A%20Excel%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2067038%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Every%20interesting.%20You've%20just%20given%20me%20hope%20I%20might%20find%20a%20way%20of%20doing%20a%20similar%20thing%20for%20a%20clickable%20map%20of%20the%20human%20body.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20posted%20it%20on%20another%20thread%20the%20other%20day%2C%20but%20as%20yet%20no%20responses.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fhow-do-i-put-multiple-clickable-cells-on-top-of-an-image-and-can%2Fm-p%2F2061523%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fhow-do-i-put-multiple-clickable-cells-on-top-of-an-image-and-can%2Fm-p%2F2061523%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2067364%22%20slang%3D%22de-DE%22%3ESubject%3A%20Excel%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2067364%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F929301%22%20target%3D%22_blank%22%3E%40nic-nicol%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EHow%20to%20create%20a%20heatmap%20(area%20map)%20in%20Excel%20(The%20site%20is%20in%20Swiss%20-%20English)%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexcelnova.org%2Fwie-man-eine-heat-map-flachenkartogramm-in-excel-erstellt%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fexcelnova.org%2Fwie-man-eine-heat-map-flachenkartogramm-in-excel-erstellt%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ENot%20sure%20if%20I%20got%20it%20right.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EBut%20think%20that%20you%20might%20be%20looking%20for%20something%20like%20that%20in%20this%20direction.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EAnyway%2C%20maybe%20that%20will%20bring%20you%20closer%20to%20your%20goal.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wish%20you%20continued%20success%20with%20Excel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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?

\

6 Replies

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

@Nikolino 

 

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

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

@Nikolino 

 

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.

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)

@Nikolino 

 

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