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
Its very Fantastic!!!!!! Thanks Master..... Best Regards from mexico.
Thank you for the information PK, I've got many ideas to use
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
Thank you for the informative ideas on Excel maps
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
You are fantastic PK, thank you so much man !!!!
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Thanks for sharing this wonderful video with explanation 👍
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
This is awesome !!! Love your work !!!
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
You are the best one, I'm from Morocco, your channel is very professional,
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Excellent work. Congratulations.
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
I learned so many things from this video thank you a lot.
@PKAnExcelExpert
2 жыл бұрын
Thanks for your valuable feedback🙏
बहुत शानदार तरीके से समझाया है आपने आपका बहुत बहुत धन्यवाद
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable your valuable
Great video. Thanks for uploading this
@PKAnExcelExpert
2 жыл бұрын
Glad you enjoyed it!
Pero veo que eso solo aplica a las versiones 2019 y office 365. Los que tenemos excel 2016 de que manera lo podemos hacer?
You are the BEST.
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Very insightful. Thanks for sharing
@PKAnExcelExpert
2 жыл бұрын
Thanks for your valuable feedback
@nonoobott8602
2 жыл бұрын
@@PKAnExcelExpert I've learned so much from your Channel. You're phenomenal
Sir you are the best, m big fan of yours
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
That is professional, can you create same this data but regarding covid-19 ? Appreciate your assistance to me. Thank you 💖💖
Is it possible to use this for floor plans? For visualization?
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)
Brother please suggest which year version of MS office would good best ???
Nice Informative!!!!
@PKAnExcelExpert
Жыл бұрын
Thanks
Again super video 👍👍
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
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?
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
3 жыл бұрын
Thanks for your valuable feedback and support 👍
Nicely explained. One problem, In my excel version Map is not working, how to activate?
Dada you are just too good. Really impressive 👏 👌 👍
@PKAnExcelExpert
3 жыл бұрын
Thank you so much 😀
@arjasarkar13
3 жыл бұрын
Do you teach Excel physically in classes I mean or Online?
You are The Best 🎊💗💖🎊
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Thank you so much
@PKAnExcelExpert
3 жыл бұрын
Welcome
very impressive demo
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Should this apply for district map with its taluka?
great sir, i also need your explanation in urdu.
Superb work Guru ji, bad luck for me is, I have been using Excel 2013.
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback. You need office 365 subscription with Excel 2016 or 2019
Thank You Sir,How can connect Stock Market Data(NSE,BSE)
Nice one sir...... 👍👌
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
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
Well-Done man. thanks for the sharing wonderful tutorial.
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Sorry at 08:26 I am not seeing an option to "color by secondary category names". What am I doing wrong?
Awesome Video
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
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
Wonderful PK
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Thanks you
@PKAnExcelExpert
3 жыл бұрын
Most welcome
Please share the same for sale in particular city
Lovely sirji , need to do some online course from ,plz guide
You are so amazing
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
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?
fantastic.
@PKAnExcelExpert
2 жыл бұрын
Thanks🙏
Can you please make one video for district wise
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?
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
Dear Brother my map is not showing in insert tab .. please guide me what should i do
I use the Excel version 2013, How can I do it?
It It possible with city wise
Sir can we create district wise stae map sales
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?
Thanks, very usefull.. Is it possible to add point location having latitude and longitude ?
@PKAnExcelExpert
3 жыл бұрын
Unfortunately not. Map charts can only plot high-level geographic details, so latitude/longitude, and street address mapping isn’t supported
@Bbhai24
3 жыл бұрын
@@PKAnExcelExpert ok thanks
Hi, how can be make all data in Block and district wise, it is possible ...???????/
Good one 👍🏻
@PKAnExcelExpert
2 жыл бұрын
Thanks for your valuable feedback
@pen_lover
2 жыл бұрын
@@PKAnExcelExpert can you please give me download link
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?
The file isn't working, even my office version there is no map option is there. I am using MS office 2015. Kindly suggest...
Hi Mr. PK, is this possible to do the same, not to link with wikipedia..?? (In excel data)
@PKAnExcelExpert
3 жыл бұрын
Yes you can do it with excel data also
Thanks for nice video. I have excel 2016 version. I am not able to see insert Map option in my excel.
@PKAnExcelExpert
3 жыл бұрын
You need to have the Office 365 subscription.
I am using excel 2013, map option is not there, how can i add map in excel.
In my Excel sheet world map is not showing? How this will be visible to ?
How if i want to use my own map...
i am unable to do this ,is not clear to me could you plz do that for a single state
I do not have map in my excel, please help Sir
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?
Sir, for making such types of map, which version of excel is required, kindly let me know
@PKAnExcelExpert
3 жыл бұрын
You need office 365 subscription with Excel 2016 or 2019
@dr.cpyadav7309
3 жыл бұрын
@@PKAnExcelExpert Thanks Sir
@kaneater1
3 жыл бұрын
Do we need internet also?
Sir how transform menu to be added
@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
good
@PKAnExcelExpert
3 жыл бұрын
Thanks
My map is not coming in the sheet. Is there anything I am missing.
How to make district map
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
3 жыл бұрын
Please watch the below given videos. kzread.info/dash/bejne/ZouM3LKLf8bQfKg.html kzread.info/dash/bejne/k41-w9Z9mbHZp7Q.html
@Cricketshorts009
3 жыл бұрын
@@PKAnExcelExpert Thank you sirji, awesome👍
Would you be willing to teach 1x1 lesson for a reasonable fee?
Hi in my excel no map is coming
what unit is area in? square kilometers? miles?
it worked. Amazing. But when I tried it using the map of the Philippines. It did not work
How can I draw a map of Africa?
Insert option mai earth nhi hai
Please start python with pandas library
@PKAnExcelExpert
3 жыл бұрын
will try
@qualityrelaxationmusic9284
3 жыл бұрын
@@PKAnExcelExpert I beleive you can do it sir. Your teaching skill is awosome.. thats why I am saying.
0:05 hehe female 69% thats right my dude I see what you did there ;)
hi
How to do it for a state and its districts