Use 3D Maps in Excel - Create Beautiful Map Charts

Поделиться
HTML-код
  • Опубликовано: 16 сен 2024

Комментарии • 80

  • @koltregaskes8385
    @koltregaskes8385 2 года назад +3

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

  • @paulseldn
    @paulseldn 5 лет назад +2

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

  • @vijaywarhate2183
    @vijaywarhate2183 4 года назад

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

    • @Computergaga
      @Computergaga  4 года назад

      You are welcome Vijay. Thank you.

  • @wayneedmondson1065
    @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!

  • @alberuni666
    @alberuni666 4 года назад +2

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

  • @robinstacpoole2667
    @robinstacpoole2667 3 года назад

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

  • @dermbro3070
    @dermbro3070 4 года назад

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

  • @saravanandilipkumar8900
    @saravanandilipkumar8900 3 года назад

    Thank You. A big Thank you

  • @Mr_Success007
    @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 .

  • @mesamwahu
    @mesamwahu 4 года назад

    Fantastic explanation. Very friendly and informative!

  • @asifrazzaq2883
    @asifrazzaq2883 4 года назад

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

  • @CS-ms8pj
    @CS-ms8pj Год назад

    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.

  • @jacquidoyle7922
    @jacquidoyle7922 4 года назад

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

  • @nawfelkhan7442
    @nawfelkhan7442 4 года назад

    Thank you its very helpful.

    • @Computergaga
      @Computergaga  4 года назад

      Glad it was helpful! Thank you, Nawfel.

  • @jeffintx
    @jeffintx 5 лет назад

    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.

  • @whitecriss
    @whitecriss 5 лет назад

    Great stuff ! Thank you very much for wonderful explanation !

  • @staker-ei4of
    @staker-ei4of 2 года назад

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

  • @jaideepdewani5444
    @jaideepdewani5444 3 года назад

    nicely explained thanks

  • @vurhd
    @vurhd 3 года назад

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

  • @aaa0669
    @aaa0669 4 года назад +1

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

  • @anujjain5989
    @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
      @anujjain5989 4 года назад

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

    • @Computergaga
      @Computergaga  4 года назад

      Thank you, Anuj.

  • @shajibahsan8267
    @shajibahsan8267 4 года назад +1

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

  • @kevinb7626
    @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

  • @nangel1001
    @nangel1001 4 года назад

    Brilliant!!

  • @inderpohir8756
    @inderpohir8756 3 года назад

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

  • @JahnnCooper
    @JahnnCooper 4 года назад

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

    • @Computergaga
      @Computergaga  4 года назад

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

    • @JahnnCooper
      @JahnnCooper 4 года назад

      @@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
    @jamietan8002 3 года назад

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

  • @John-qb3dn
    @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?

  • @charlenestewart7395
    @charlenestewart7395 Год назад

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

  • @mich9043
    @mich9043 3 года назад

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

  • @PeculiarK8Atelier
    @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?

  • @briandennehy6380
    @briandennehy6380 5 лет назад

    Lovely stuff

  • @hirwahubert5531
    @hirwahubert5531 3 года назад

    How can i save the map without screenshoting it?

  • @AKASHMANDAL2386
    @AKASHMANDAL2386 4 года назад

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

  • @dralvess100
    @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
      @SforShivani 4 года назад

      Yes. It is possible. Turn the map into video and embed. Watch it here: ruclips.net/video/A9p04c1VehU/видео.html

  • @jeraldthalaiva85
    @jeraldthalaiva85 11 месяцев назад

    Sir pls upload the practice file..

    • @Computergaga
      @Computergaga  11 месяцев назад

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

  • @doctorsmith3147
    @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
      @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.

  • @BrooklynDesigne
    @BrooklynDesigne 3 года назад

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

  • @corinto1977
    @corinto1977 3 года назад

    how do I save a geospatial map and share it?

  • @theroyalzz4420
    @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
      @Computergaga  4 года назад

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

  • @fitabatv
    @fitabatv 5 лет назад

    Is it wonderful I like this feature

    • @Computergaga
      @Computergaga  5 лет назад

      yes it is great. Thank you Thierno.

  • @EngrWUAV
    @EngrWUAV 3 года назад

    Can be apply this in microsoft escel 2010?

    • @Computergaga
      @Computergaga  3 года назад

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

  • @14teoniko
    @14teoniko 4 года назад

    What if the 3d maps button does not appear? What should I do?

  • @uncommonsense6022
    @uncommonsense6022 5 лет назад

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

    • @Computergaga
      @Computergaga  5 лет назад

      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.

  • @anuppathak7776
    @anuppathak7776 3 года назад

    Can't show value in map

  • @kmahim82
    @kmahim82 3 года назад

    How to do the same thing in Mac?

    • @Computergaga
      @Computergaga  3 года назад +1

      I don't know. I don't use a Mac.

    • @kmahim82
      @kmahim82 3 года назад

      @@Computergaga :( We Mac users need help too… don’t leave us alone :(

    • @Computergaga
      @Computergaga  3 года назад

      😊

  • @abdurrahimeskin4912
    @abdurrahimeskin4912 4 года назад

    May I merry with your pronunciation?