Use 3D Maps in Excel - Create Beautiful Map Charts

Рет қаралды 184,739

Күн бұрын

In this video, we look at how to use the 3D Map charts in Excel to create beautiful geographic insights.
These charts are only available in Excel 2013 - known as Power Maps - and Excel 2016 as 3D Maps.
3D maps allow us to create insights into our data that we cannot do with regular charts. To be able to map data geographically and see patterns.
These charts provide plenty of functionality to navigate, zoom, adjust charts types, formatting and much more. You can then export your visual as a video or an image.
Find more great free tutorials at;
www.computergaga.com
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/UltimateExcel
Excel VBA for Beginners ► bit.ly/2JvnnRv
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2t3netw
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2viGg3J
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1

Пікірлер: 80

@dermbro3070 4 жыл бұрын

This is such a great explanation. Thank you very much, Computergaga!

@Computergaga 4 жыл бұрын

You're very welcome.

@paulseldn 5 жыл бұрын

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

@Computergaga 5 жыл бұрын

You're very welcome.

@asifrazzaq2883 4 жыл бұрын

Very informative, Thank You ! looking forward for other contents by you

@Computergaga 4 жыл бұрын

Thank you Asif.

@jacquidoyle7922 4 жыл бұрын

Thank you! Fantastic to learn about this feature :) Cheers!

@Computergaga 4 жыл бұрын

You're welcome Jacqui.

@whitecriss 5 жыл бұрын

Great stuff ! Thank you very much for wonderful explanation !

@Computergaga 5 жыл бұрын

Thank you Cristian.

@wayneedmondson1065 5 жыл бұрын

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!

@Computergaga 5 жыл бұрын

Thank you Wayne.

@mesamwahu 4 жыл бұрын

Fantastic explanation. Very friendly and informative!

@Computergaga 4 жыл бұрын

Thank you.

@alberuni666 4 жыл бұрын

Great video! Thanks! Can you please tell me how to make the value of those columns representing height visible?

@vijaywarhate2183 4 жыл бұрын

Very useful and exact information with proper explanation. Thank You.

@Computergaga 4 жыл бұрын

You are welcome Vijay. Thank you.

@Mr_Success007 4 жыл бұрын

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 .

@nawfelkhan7442 4 жыл бұрын

Thank you its very helpful.

@Computergaga 4 жыл бұрын

Glad it was helpful! Thank you, Nawfel.

@nangel1001 4 жыл бұрын

Brilliant!!

@Computergaga 4 жыл бұрын

Thank you very much, Nicki.

@koltregaskes8385 2 жыл бұрын

Great video. How do you insert the finished map onto a worksheet so an end user can see it and refresh it?

@briandennehy6380 5 жыл бұрын

Lovely stuff

@Computergaga 5 жыл бұрын

Thank you Brian.

@jeffintx 4 жыл бұрын

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 4 жыл бұрын

Thank you Jeff.

@saravanandilipkumar8900 3 жыл бұрын

Thank You. A big Thank you

@Computergaga 2 жыл бұрын

You are welcome!

@jaideepdewani5444 3 жыл бұрын

nicely explained thanks

@Computergaga 3 жыл бұрын

Thank you, Jaideep.

@CS-ms8pj 11 ай бұрын

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.

@vurhd 2 жыл бұрын

Great video, how do you resolve post codes it doesn't automatically pick up?

@PeculiarK8Atelier 3 жыл бұрын

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?

@kevinb7626 Жыл бұрын

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

@inderpohir8756 3 жыл бұрын

Great sir, Can you help me to make a map cities wise...

@robinstacpoole2667 3 жыл бұрын

Good introduction. Suggest starting at 2:00. Leaves me needing to find out more about layers though

@Computergaga 3 жыл бұрын

Thank you, Robin.

@shajibahsan8267 4 жыл бұрын

How can I add custom labels, say post code in MAP ?

@John-qb3dn 3 жыл бұрын

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?

@aaa0669 4 жыл бұрын

Does it map Australian data? It seems to be find with american locations but nowhere else....

@staker-ei4of 2 жыл бұрын

You're link to the practice datasets brings me to a dating site thing lol

@Computergaga 2 жыл бұрын

Removed.

@AKASHMANDAL2386 4 жыл бұрын

Can we publish this 3D map to online.so any one can see the map

@charlenestewart7395 10 ай бұрын

How do i get the map in excel and it be interactive with a slider and other data?

@mich9043 3 жыл бұрын

I want to plot latitude and longitude points is there a way to do that

@JahnnCooper 3 жыл бұрын

great video, very clear! Anything similar for MAC??? Gutted that excel for Mac doesn't have it

@Computergaga 3 жыл бұрын

Thank you, Jahnn. I don't have a Mac so can't answer the question.

@JahnnCooper 3 жыл бұрын

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

@jamietan8002 3 жыл бұрын

The 3D map does not support other countries map that well right? like Singapore?

@fitabatv 5 жыл бұрын

Is it wonderful I like this feature

@Computergaga 5 жыл бұрын

yes it is great. Thank you Thierno.

@dralvess100 4 жыл бұрын

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?

@SforShivani 4 жыл бұрын

Yes. It is possible. Turn the map into video and embed. Watch it here: kzfaq.info/get/bejne/d5-gY5eUlrzJmIk.html

@anujjain5989 4 жыл бұрын

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.

@anujjain5989 4 жыл бұрын

Ignore the query, how to add Labels. Thanks to share the wonderful process.

@Computergaga 4 жыл бұрын

Thank you, Anuj.

@corinto1977 3 жыл бұрын

how do I save a geospatial map and share it?

@doctorsmith3147 4 жыл бұрын

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?

@Computergaga 4 жыл бұрын

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.

@hirwahubert5531 3 жыл бұрын

How can i save the map without screenshoting it?

@BrooklynDesigne 3 жыл бұрын

How to install 3D maps? My actual version 16.46.

@theroyalzz4420 4 жыл бұрын

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

@Computergaga 4 жыл бұрын

It should be in 2019 so it might be a Mac thing. I don't use a Mac so unsure on that.

@EngrWUAV 3 жыл бұрын

Can be apply this in microsoft escel 2010?

@Computergaga 3 жыл бұрын

I don't believe it is available in that version.

@jeraldthalaiva85 9 ай бұрын

Sir pls upload the practice file..

@Computergaga 9 ай бұрын

Hi, sorry but I no longer have the practise file for this video.

@uncommonsense6022 4 жыл бұрын

why might my height values be stuck on count? Cant get it to sum.

@Computergaga 4 жыл бұрын

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.