Thanks for this. I wanted to have a new map for each tab, so you could look at say the schedule on a map for Aug, Sept etc. I can see the 'new tour' option, but it's still referencing data from the 1st tab only. I've tried refresh data to no avail.
On an Excel 3D Mapping heat map, if multiple unique data points have the same set of coordinates, is that spot weighted as having multiple data points or just one? I hoped it would be multiple, however it kind of looks like just one but I don’t know if there is a solution. Thanks
Thank you for the video can you please make another video and explain every options in details . e.g the options for categorises , location and so fort .
Very nice presentation. Good basic intro to 3D Maps. When you have time, I would appreciate it if you could show how to input a shapefile and display data on it.
@@Computergaga Had to download parallels and excel for windows. You have such a gift of teaching, all very clear and easy to follow. Awesome proper brit accent too haha. Just a question: can you change settings for the Bing map style, colours, etc. ?
Thank You. I have a question: Is there a way to put this map (created using 3dmaps tool) inside a worksheet? I mean, not the print screen, but the "dynamic map". It would be marvelous if we change the data and the map change too.....is it possible?
Thank you for the useful video, but I was not successful in adding text to the shape. I wanted to write the % and the country beside or over the shape but when I add the text box it just floats around - it is not connected to the shape, and when I add an annotation it makes an annoying grey triangle and a distance from the shape. Is there a way I am missing?
would love to be able to use this feature but 3d maps on my computer is stuck using the same data every time I open it. Does anyone know how to change the dataset 3d maps is pulling from?
Great Video - but I have an issue I cant solve. Whenever I move my revenue data to the height filed it appears as COUNT rather than SUM. I don see any way of fixing this? Any ideas?
Thank you. If it defaults to count it normally means there are blanks cells or something formatted as text in the revenue column. Maybe you selected the entire column for the map.
I have office 365 from school, 2019, version 16.30 but i cant see the power maps or 3d maps button? if i go to add ins i can only go to the add ins store but dont see power maps in there? where can i find this? im on mac as well if that makes a difference
This normally indicates they, or some, or stored as text. If you check the source data. Try selecting the column in the sources data and check if it sums them in the bottom right of the screen.
I so love this video. Your patience while teaching is masterclass. Flowers for you🥀🥀🌹
Thank you so much!
Great video. How do you insert the finished map onto a worksheet so an end user can see it and refresh it?
Thanks for this. I wanted to have a new map for each tab, so you could look at say the schedule on a map for Aug, Sept etc. I can see the 'new tour' option, but it's still referencing data from the 1st tab only. I've tried refresh data to no avail.
Very useful and exact information with proper explanation. Thank You.
You are welcome Vijay. Thank you.
Great video, how do you resolve post codes it doesn't automatically pick up?
Nice easy explanation and not too fast. Many thanks for my intro into 3D Maps. I see now the power of this fantastic tool. Bless you :)
You're very welcome.
Thank you so much for this explication
You're very welcome.
Great video! Thanks! Can you please tell me how to make the value of those columns representing height visible?
Good introduction. Suggest starting at 2:00. Leaves me needing to find out more about layers though
Thank you, Robin.
On an Excel 3D Mapping heat map, if multiple unique data points have the same set of coordinates, is that spot weighted as having multiple data points or just one? I hoped it would be multiple, however it kind of looks like just one but I don’t know if there is a solution. Thanks
This is such a great explanation. Thank you very much, Computergaga!
You're very welcome.
Thank you its very helpful.
Glad it was helpful! Thank you, Nawfel.
Hi Alan.. great video and intro to 3D Maps. Now that you have shown what they can do, I'll definitely experiment with the options. Thumbs up!
Thank you Wayne.
Hi , This was really great ,I follow all the steps. I have only one question ,I want present state wise Value , how can i add values in labels.
Ignore the query, how to add Labels. Thanks to share the wonderful process.
Thank you, Anuj.
Thank you for the video can you please make another video and explain every options in details . e.g the options for categorises , location and so fort .
Very informative, Thank You ! looking forward for other contents by you
Thank you Asif.
Thank you! Fantastic to learn about this feature :) Cheers!
You're welcome Jacqui.
Thank You. A big Thank you
You are welcome!
nicely explained thanks
Thank you, Jaideep.
Fantastic explanation. Very friendly and informative!
Thank you.
Great sir,
Can you help me to make a map cities wise...
Do you know how to cite this feature in a manuscript?
Great stuff ! Thank you very much for wonderful explanation !
Thank you Cristian.
You're link to the practice datasets brings me to a dating site thing lol
Removed.
Very nice presentation. Good basic intro to 3D Maps. When you have time, I would appreciate it if you could show how to input a shapefile and display data on it.
Thank you Jeff.
great video, very clear! Anything similar for MAC??? Gutted that excel for Mac doesn't have it
Thank you, Jahnn. I don't have a Mac so can't answer the question.
@@Computergaga Had to download parallels and excel for windows. You have such a gift of teaching, all very clear and easy to follow. Awesome proper brit accent too haha. Just a question: can you change settings for the Bing map style, colours, etc. ?
Thank You. I have a question: Is there a way to put this map (created using 3dmaps tool) inside a worksheet? I mean, not the print screen, but the "dynamic map". It would be marvelous if we change the data and the map change too.....is it possible?
Yes. It is possible. Turn the map into video and embed. Watch it here: ua-cam.com/video/A9p04c1VehU/v-deo.html
Does it map Australian data? It seems to be find with american locations but nowhere else....
The 3D map does not support other countries map that well right? like Singapore?
How do i get the map in excel and it be interactive with a slider and other data?
I want to plot latitude and longitude points is there a way to do that
Thank you for the useful video, but I was not successful in adding text to the shape. I wanted to write the % and the country beside or over the shape but when I add the text box it just floats around - it is not connected to the shape, and when I add an annotation it makes an annoying grey triangle and a distance from the shape. Is there a way I am missing?
would love to be able to use this feature but 3d maps on my computer is stuck using the same data every time I open it. Does anyone know how to change the dataset 3d maps is pulling from?
How can I add custom labels, say post code in MAP ?
Can we publish this 3D map to online.so any one can see the map
Brilliant!!
Thank you very much, Nicki.
How can i save the map without screenshoting it?
Great Video - but I have an issue I cant solve. Whenever I move my revenue data to the height filed it appears as COUNT rather than SUM. I don see any way of fixing this? Any ideas?
Thank you. If it defaults to count it normally means there are blanks cells or something formatted as text in the revenue column. Maybe you selected the entire column for the map.
how do I save a geospatial map and share it?
How to install 3D maps? My actual version 16.46.
Can be apply this in microsoft escel 2010?
I don't believe it is available in that version.
Sir pls upload the practice file..
Hi, sorry but I no longer have the practise file for this video.
Lovely stuff
Thank you Brian.
I have office 365 from school, 2019, version 16.30 but i cant see the power maps or 3d maps button? if i go to add ins i can only go to the add ins store but dont see power maps in there? where can i find this? im on mac as well if that makes a difference
It should be in 2019 so it might be a Mac thing. I don't use a Mac so unsure on that.
What if the 3d maps button does not appear? What should I do?
Activate it from the add-ins option of Excel
It will appear
How to do the same thing in Mac?
I don't know. I don't use a Mac.
@@Computergaga :( We Mac users need help too… don’t leave us alone :(
😊
Is it wonderful I like this feature
yes it is great. Thank you Thierno.
why might my height values be stuck on count? Cant get it to sum.
This normally indicates they, or some, or stored as text. If you check the source data. Try selecting the column in the sources data and check if it sums them in the bottom right of the screen.
Can't show value in map
May I merry with your pronunciation?