Dynamic Filled map in Excel | Connect with Wikipedia page to get population Data

#FilledMap #Visulaization
Hello Friends,
In this video you will learn how to create a dynamic Map in Microsoft Excel. We have explained 2 example. First how to fetch Population, Area and Density data from Wikipedia page using Power Query and display on the Map. Second, we have connect with the excel table State wise sales data. Office 365 subscription is required to create a filled map.
Download the practice file from below given link:
www.pk-anexcelexpert.com/dyna...
Wikipedia page link to get the state wise data
en.wikipedia.org/wiki/List_of...
Download the Free Project Management Dashboard
www.pk-anexcelexpert.com/exce...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/shop/pkanexcele...

Пікірлер: 131

  • @cesarsaldana3429
    @cesarsaldana34293 жыл бұрын

    Its very Fantastic!!!!!! Thanks Master..... Best Regards from mexico.

  • @surasako2003
    @surasako20033 жыл бұрын

    Thank you for the information PK, I've got many ideas to use

  • @aulianaurma4453
    @aulianaurma44533 жыл бұрын

    asli ini keren bgt ,, mksh ya udah sher ilmu nya ,, I would love to meet you to learn a lot you are a very great person in this field

  • @arnoldasava
    @arnoldasava3 жыл бұрын

    Thank you for the informative ideas on Excel maps

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @MasterJorge100
    @MasterJorge1003 жыл бұрын

    You are fantastic PK, thank you so much man !!!!

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @rukhsanashaikh3623
    @rukhsanashaikh36233 жыл бұрын

    Thanks for sharing this wonderful video with explanation 👍

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @gorgondas
    @gorgondas3 жыл бұрын

    This is awesome !!! Love your work !!!

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @zacompta
    @zacompta3 жыл бұрын

    You are the best one, I'm from Morocco, your channel is very professional,

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @MohamedAli-co7dc
    @MohamedAli-co7dc3 жыл бұрын

    Excellent work. Congratulations.

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @kubracakr1335
    @kubracakr13352 жыл бұрын

    I learned so many things from this video thank you a lot.

  • @PKAnExcelExpert

    @PKAnExcelExpert

    2 жыл бұрын

    Thanks for your valuable feedback🙏

  • @AbhishekMishra-cr1tz
    @AbhishekMishra-cr1tz3 жыл бұрын

    बहुत शानदार तरीके से समझाया है आपने आपका बहुत बहुत धन्यवाद

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable your valuable

  • @ianodonoghue6011
    @ianodonoghue60112 жыл бұрын

    Great video. Thanks for uploading this

  • @PKAnExcelExpert

    @PKAnExcelExpert

    2 жыл бұрын

    Glad you enjoyed it!

  • @henryleonrivera7385
    @henryleonrivera73853 жыл бұрын

    Pero veo que eso solo aplica a las versiones 2019 y office 365. Los que tenemos excel 2016 de que manera lo podemos hacer?

  • @Balwan_Singh
    @Balwan_Singh3 жыл бұрын

    You are the BEST.

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @nonoobott8602
    @nonoobott86022 жыл бұрын

    Very insightful. Thanks for sharing

  • @PKAnExcelExpert

    @PKAnExcelExpert

    2 жыл бұрын

    Thanks for your valuable feedback

  • @nonoobott8602

    @nonoobott8602

    2 жыл бұрын

    @@PKAnExcelExpert I've learned so much from your Channel. You're phenomenal

  • @creative_gujarati
    @creative_gujarati3 жыл бұрын

    Sir you are the best, m big fan of yours

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @user-pw1hh9qo5v
    @user-pw1hh9qo5v3 жыл бұрын

    That is professional, can you create same this data but regarding covid-19 ? Appreciate your assistance to me. Thank you 💖💖

  • @lucioa.delmoresjr.7962
    @lucioa.delmoresjr.79622 жыл бұрын

    Is it possible to use this for floor plans? For visualization?

  • @matlholelosaba4977
    @matlholelosaba4977 Жыл бұрын

    Is there a way to reference the rich data cell (e.g. Rajasthan state) in an Excel Function such as XLOOKUP for further calculations? Excel functions seem to have a problem when including such cells. =XLOOKUP(Rajasthan,India[State],B:B)

  • @bsanju585
    @bsanju5853 жыл бұрын

    Brother please suggest which year version of MS office would good best ???

  • @jamesjai100
    @jamesjai100 Жыл бұрын

    Nice Informative!!!!

  • @PKAnExcelExpert

    @PKAnExcelExpert

    Жыл бұрын

    Thanks

  • @piarchanddogra1659
    @piarchanddogra16593 жыл бұрын

    Again super video 👍👍

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @dezeindra2190
    @dezeindra21902 жыл бұрын

    Hi PK, thank you for this video. PK, is that possible if i have my own map in CAD format to use as dynamic filled map in excel?

  • @evincedintentions6821
    @evincedintentions68213 жыл бұрын

    Thank you PK. Can't really thank you enough. I think you should put in your paypal account for anyone that wants to donate to your channel. Thank you again. The Universe will reward you.

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback and support 👍

  • @janak257
    @janak2573 жыл бұрын

    Nicely explained. One problem, In my excel version Map is not working, how to activate?

  • @arjasarkar13
    @arjasarkar133 жыл бұрын

    Dada you are just too good. Really impressive 👏 👌 👍

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thank you so much 😀

  • @arjasarkar13

    @arjasarkar13

    3 жыл бұрын

    Do you teach Excel physically in classes I mean or Online?

  • @ramdashwant2024
    @ramdashwant20243 жыл бұрын

    You are The Best 🎊💗💖🎊

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @zacompta
    @zacompta3 жыл бұрын

    Thank you so much

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Welcome

  • @AnandPenmatcha
    @AnandPenmatcha3 жыл бұрын

    very impressive demo

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @satishsalunke6283
    @satishsalunke62833 жыл бұрын

    Should this apply for district map with its taluka?

  • @khalidmajeed2886
    @khalidmajeed28863 жыл бұрын

    great sir, i also need your explanation in urdu.

  • @amirsaiftaz
    @amirsaiftaz3 жыл бұрын

    Superb work Guru ji, bad luck for me is, I have been using Excel 2013.

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback. You need office 365 subscription with Excel 2016 or 2019

  • @ckprakash7708
    @ckprakash77083 жыл бұрын

    Thank You Sir,How can connect Stock Market Data(NSE,BSE)

  • @pankaj4kamal
    @pankaj4kamal3 жыл бұрын

    Nice one sir...... 👍👌

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @VinitRatan
    @VinitRatan3 жыл бұрын

    Dear PK Sir, Example worked but when I'm trying to make chart of this link "en.wikipedia.org/wiki/List_of_districts_of_Rajasthan" it's not showing the geographical chart kindly help over it. Regards

  • @MrAimalsultani
    @MrAimalsultani3 жыл бұрын

    Well-Done man. thanks for the sharing wonderful tutorial.

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @knowledgevoyage8828
    @knowledgevoyage88282 жыл бұрын

    Sorry at 08:26 I am not seeing an option to "color by secondary category names". What am I doing wrong?

  • @seshadrir85
    @seshadrir853 жыл бұрын

    Awesome Video

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @basavarajus2061
    @basavarajus2061 Жыл бұрын

    Hi PK, your map is working great, thank you. I am facing one problem for india map, i see Tibet appearing and Arunachala Pradesh data being highlighted on that, how can I troubleshoot this, kindly help

  • @lukev730
    @lukev7303 жыл бұрын

    Wonderful PK

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @MohamedAhmed-xq1dq
    @MohamedAhmed-xq1dq3 жыл бұрын

    Thanks you

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Most welcome

  • @tusharshinde4790
    @tusharshinde47903 жыл бұрын

    Please share the same for sale in particular city

  • @amiitmish3
    @amiitmish33 жыл бұрын

    Lovely sirji , need to do some online course from ,plz guide

  • @lindadevita6667
    @lindadevita66673 жыл бұрын

    You are so amazing

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @aamirkayda1513
    @aamirkayda1513 Жыл бұрын

    Sir thankyou for the video.I want to create a map chart for my bibilographic data, i followed the steps from the video but still only a blank chart appears. can you please tell where am i going wrong?

  • @diliprpanchamia
    @diliprpanchamia2 жыл бұрын

    fantastic.

  • @PKAnExcelExpert

    @PKAnExcelExpert

    2 жыл бұрын

    Thanks🙏

  • @rajukadam8141
    @rajukadam81416 ай бұрын

    Can you please make one video for district wise

  • @DanielPm23
    @DanielPm233 жыл бұрын

    I have a problem when i change the data type from text to decimal number, it shows up "Error" in some regions, any idea why is this happening?

  • @messaoudi0707
    @messaoudi07073 жыл бұрын

    Hi, it's better to choice space and k in "text before delimiter" to extract exactly only number in the AREA. When you extract only k you will end up with number and space. In the transformation power query is smart enough to recognize number and space as number. But you better do it right

  • @adnanmajeed8673
    @adnanmajeed86733 жыл бұрын

    Dear Brother my map is not showing in insert tab .. please guide me what should i do

  • @cspsopheak2141
    @cspsopheak2141 Жыл бұрын

    I use the Excel version 2013, How can I do it?

  • @swapnilborhade5154
    @swapnilborhade51543 жыл бұрын

    It It possible with city wise

  • @gauravsamota8579
    @gauravsamota8579 Жыл бұрын

    Sir can we create district wise stae map sales

  • @accountsabsk
    @accountsabsk5 ай бұрын

    I made the map as you showed. When I am selecting a single state, say Uttar Pradesh, it is showing map of whole world then highlighting UP. I want the map of one state only. What to do?

  • @Bbhai24
    @Bbhai243 жыл бұрын

    Thanks, very usefull.. Is it possible to add point location having latitude and longitude ?

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Unfortunately not. Map charts can only plot high-level geographic details, so latitude/longitude, and street address mapping isn’t supported

  • @Bbhai24

    @Bbhai24

    3 жыл бұрын

    @@PKAnExcelExpert ok thanks

  • @lokeshsingh2026
    @lokeshsingh2026 Жыл бұрын

    Hi, how can be make all data in Block and district wise, it is possible ...???????/

  • @sourabhray5903
    @sourabhray59032 жыл бұрын

    Good one 👍🏻

  • @PKAnExcelExpert

    @PKAnExcelExpert

    2 жыл бұрын

    Thanks for your valuable feedback

  • @pen_lover

    @pen_lover

    2 жыл бұрын

    @@PKAnExcelExpert can you please give me download link

  • @sazibmiah1934
    @sazibmiah19343 жыл бұрын

    I want to highlight two districts in Bangladesh but I can't because Wikipedia does not have district-level density information. would you please help me?

  • @LARflixMovies
    @LARflixMovies3 жыл бұрын

    The file isn't working, even my office version there is no map option is there. I am using MS office 2015. Kindly suggest...

  • @tejukumara5431
    @tejukumara54313 жыл бұрын

    Hi Mr. PK, is this possible to do the same, not to link with wikipedia..?? (In excel data)

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Yes you can do it with excel data also

  • @vishalsaraswat947
    @vishalsaraswat9473 жыл бұрын

    Thanks for nice video. I have excel 2016 version. I am not able to see insert Map option in my excel.

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    You need to have the Office 365 subscription.

  • @ravindramali355
    @ravindramali3552 жыл бұрын

    I am using excel 2013, map option is not there, how can i add map in excel.

  • @rashidmehmood3954
    @rashidmehmood3954 Жыл бұрын

    In my Excel sheet world map is not showing? How this will be visible to ?

  • @dezeindra2190
    @dezeindra21902 жыл бұрын

    How if i want to use my own map...

  • @kritiraj715
    @kritiraj7153 жыл бұрын

    i am unable to do this ,is not clear to me could you plz do that for a single state

  • @dr.cpyadav7309
    @dr.cpyadav73093 жыл бұрын

    I do not have map in my excel, please help Sir

  • @086sumit
    @086sumit Жыл бұрын

    I am getting an error of " there was a problem finding your map". Please help ..do I need to have access of internet while using map?

  • @dr.cpyadav7309
    @dr.cpyadav73093 жыл бұрын

    Sir, for making such types of map, which version of excel is required, kindly let me know

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    You need office 365 subscription with Excel 2016 or 2019

  • @dr.cpyadav7309

    @dr.cpyadav7309

    3 жыл бұрын

    @@PKAnExcelExpert Thanks Sir

  • @kaneater1

    @kaneater1

    3 жыл бұрын

    Do we need internet also?

  • @sanjayapatra1
    @sanjayapatra13 жыл бұрын

    Sir how transform menu to be added

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    It is available in Excel 2016 and above version. For Excel 2010 or 2013 please watch below video series Power Query for Excel: kzread.info/head/PLbDvAYjpWJ7DYKQqZYiATs-8AmK2UUs-3

  • @sanilalkuttimon1755
    @sanilalkuttimon17553 жыл бұрын

    good

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks

  • @navinrawat2043
    @navinrawat2043 Жыл бұрын

    My map is not coming in the sheet. Is there anything I am missing.

  • @vishalgawali2476
    @vishalgawali24762 жыл бұрын

    How to make district map

  • @Cricketshorts009
    @Cricketshorts0093 жыл бұрын

    Hey PK, please share a video on how to connect ms excel to ms access... If there is a user form in ms excel and that data i need to store in Ms access... By linking it is easy...but through vba code how that dat will get stored in ms access..please help🙏

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Please watch the below given videos. kzread.info/dash/bejne/ZouM3LKLf8bQfKg.html kzread.info/dash/bejne/k41-w9Z9mbHZp7Q.html

  • @Cricketshorts009

    @Cricketshorts009

    3 жыл бұрын

    @@PKAnExcelExpert Thank you sirji, awesome👍

  • @meerapatel3352
    @meerapatel33523 жыл бұрын

    Would you be willing to teach 1x1 lesson for a reasonable fee?

  • @kavyashukla3244
    @kavyashukla32443 жыл бұрын

    Hi in my excel no map is coming

  • @WhiteShadow4689
    @WhiteShadow4689Ай бұрын

    what unit is area in? square kilometers? miles?

  • @makicrespo7022
    @makicrespo7022 Жыл бұрын

    it worked. Amazing. But when I tried it using the map of the Philippines. It did not work

  • @TheMinstrel55
    @TheMinstrel552 жыл бұрын

    How can I draw a map of Africa?

  • @wardhanschannel9748
    @wardhanschannel97483 жыл бұрын

    Insert option mai earth nhi hai

  • @qualityrelaxationmusic9284
    @qualityrelaxationmusic92843 жыл бұрын

    Please start python with pandas library

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    will try

  • @qualityrelaxationmusic9284

    @qualityrelaxationmusic9284

    3 жыл бұрын

    @@PKAnExcelExpert I beleive you can do it sir. Your teaching skill is awosome.. thats why I am saying.

  • @Cam-sl8ve
    @Cam-sl8ve2 жыл бұрын

    0:05 hehe female 69% thats right my dude I see what you did there ;)

  • @kritiraj715
    @kritiraj7153 жыл бұрын

    hi

  • @lk9569
    @lk956922 күн бұрын

    How to do it for a state and its districts