How to make a Map Chart in Excel - Quick & Simple Tutorial

Рет қаралды 32,110

Күн бұрын

You can create easy and powerful map charts in Excel in just 3 steps.
1) Select your data (geographical column and some numeric column)
2) Go to Insert Ribbon and click on Maps → Filled Map
3) There is no step 3. Your map is ready!
Get the sample file and more from here 👉 chandoo.org/wp/interactive-ma...
~
More on charting:
I love making beautiful & insightful charts. Do watch these other tutorials for some tips & wins on making amazing charts.
Budget vs. Actual chart (must watch) - • Make a BEAUTIFUL Budge...
Waffle chart (yummy) - • Impress your boss with...
Dynamic chart with Check boxes (Crazy) - • Make an AWESOME Dynami...
Top 5 items in the chart - • Create a Top 5 Dynamic...
Advanced Gantt chart - • Advanced Gantt chart i...
Risk map - • How to create risk map...
Charting tips & tutorials - PLAYLIST - • Smart Charts for Story...
~
Even more on charting & advanced charting:
I cover charting & data analysis extensively in my online course. Consider joining that program if you want to become a master storyteller with your data. Visit chandoo.org/wp/excel-school-p... to sign up.
~
#charting #excel

Пікірлер: 47

@chrism9037 Жыл бұрын

Thanks for the video Chandoo, very cool!

@sravanthikondeti6303 6 ай бұрын

Hi Chando , I am from France you are doing great help for our carrier growth according to your videos I changed my working pattens,thank u so much 😊

@HamdanYouTuber Жыл бұрын

I learn a lot from your channel, thank you.

@promiseuzondu8735 Жыл бұрын

Hi Chando, I am from Nigeria and I appreciate the great work you put in attempt to educate lots of people across the world. However, I would like to know the possibility of creating such map for countries like Nigeria, or even a local government area in Nigeria?

@atimstella1899 Жыл бұрын

Good question

@CaribouDataScience Жыл бұрын

Thanks, that was easy!

@Amank3107 Жыл бұрын

Hey thanks for this awesome video can we have the excel 3D Map please

@shahidpervez575 Жыл бұрын

You have been my mentor from the starting I request KZfaq please help me in this problem. How to change the text into date format

@BillahaMdMasum Жыл бұрын

would like watch again and again.

@barttitulaerexcelbart9400 Жыл бұрын

Hi Chandoo, thanks. The different map types are visible if you project the globe, say world. On Linkend in learning there is a course of #René Martin

@sunnysun6567 Жыл бұрын

Can you do some A/B testing example ??

@AlAmineDiagne 18 күн бұрын

Hello Chandoo, I want to visualise two metrics in a filled map ? Is it possible to do it with Excel ?

@AbdulRahmaan-ic6hk Жыл бұрын

Which version of excel is needed for this map insert ? I am using win 32 & excel version - professional 2016. It shows "this chart isn't available in your version of excel"

@tTiger-kz3ly Жыл бұрын

I have two questions: 1.does data engineer need a good communication skill, and be good at math? 2.can work as freelancer as data engineer? Thanks

@hendryns2419 Жыл бұрын

is this applicable to every city around the world?

@MantuYadavYM 10 ай бұрын

After watching *Code basics Hindi* channel I am here

@nnandan9431 Жыл бұрын

When we create 3d map Australia doesn't appeared, do you know whats the reason?

@maraki199077 8 ай бұрын

Hello Chandoo, thank you for this video very helpful! On my map, could I colour each country/state with the colour of my choice or does it have to be a gradient colour always indicating the comparison between values/numbers (e.g., sales?). I would like for example to mark some countries in blue (where we do business) and some in red (where we have offices) etc. Is that possible in Excel? Thank you.

@chandoo_ 8 ай бұрын

Unfortunately, it can only be a gradient color.

@maraki199077 8 ай бұрын

@@chandoo_ too good to be true...! Thank you so much for the quick reply, much appreciated!

@chandoo_ 8 ай бұрын

If you just want two colors (blue and red), you can still use the gradient option. Set up countries in A1:A10 and doing business in B1:B10, set the value in column B as 1 for doing business and 0 for not. Then create the graph, set the gradient from RED to BLUE with boundary values as 0 and 1. This will automatically color code the graph as you want.

@maraki199077 8 ай бұрын

@@chandoo_ oh wow, would not have thought of that (I am not an excel person obviously!😅) Thank you so much! 🙏

@Krishna-kb9ul Жыл бұрын

Sir , recently i got an offer as a business intelligence analyst, i always wanted to be a data scientist and i have done courses , is it advisable to start my career as business intelligence analyst . The company use jedox for analysis not python or r

@husainabbas9533 Жыл бұрын

Hi chandoo, I have around 6500 xml files and each xml file contains some data for healthcare claims. I want to load this xml files into one single excel file how I can do it. It tried using Powerquery but it gives me only 6500 rows with names of each xml file. Please help me to do this

@ranjitsinghnegi1608 10 ай бұрын

Hi Hussain Ji, U can try this. 1. Using Excel's Import Data Feature: a. Open Excel and go to the "Data" tab. b. Click on "From XML" in the "Get External Data" section. c. Browse and select the first XML file you want to import. d. Excel will display a preview of the XML structure. Adjust any import options if needed. e. Click "OK" to import the data into Excel. f. Repeat steps c to e for each XML file you want to import. Each file will be imported into a separate worksheet. 2. U can use script or programming like VBA or Python, the latter will be the best. I hope U'll be able to solve UR situation.

@drkesavsarma_singer Жыл бұрын

How can we make dashboards / visualisations with the help of AI in just 2 minutes ? Also, please make some videos about PowerPoint presentation, m.s.word as well...using AI.

@ashiqshanavas375 Жыл бұрын

Sir i VLOOKUPed some data and I need the link of that amount from where that amount is came, as that we know that CTRL+[ take up us to the link of that amount since when we manually put the formulas like =to the cell we click we want ,then when we click CTRL+[ thereby they take up us to the AMOUNT but when we Vlookup and check for link by clicking CTRL+[ they take up us to the LOOKUP VALUE but I NEED TO GET THE CELL REFERENCE OF THAT AMOUNT we Lookuped by Clicking CTRL+[ .Is there any solution for that Sir,really urgent sir .If u provide the idea it will be a great help for me.

@chandoo_ Жыл бұрын

If you are using XLOOKUP, you can try =CELL("address", XLOOKUP(your_lookup_formula)) VLOOKUP doesn't return references. So another option is to use INDEX MATCH which can return references and then pass the result to CELL like above.

@searchis Жыл бұрын

Replace chocolate 🎉

@saranyaselvaraj1828 8 ай бұрын

Hi Chandoo, I wanted to create a map for the districts of a state in India. I am getting the state but not able to see the districts/cities. Would it be possible to create a map with the cities of a state. Please advise. Thank you

@chandoo_ 8 ай бұрын

As of now, Excel maps do not support Indian districts. May be in future?

@joedi Жыл бұрын

NZ maps are a nightmare. Especially when using pbi. The stats nz variables keep changing. Getting a list of meshblocks and matching area units and meshblock and the Stat Areas 1 and 2 and with census 2023 Stat area 3 being introduced, I tremble in fear.

@chandoo_ Жыл бұрын

That is right. I wanted to make this example with NZ data but it looked pathetic. So went with Ohio data.

@debzeb6899 Жыл бұрын

I got settled in for my NZ nightmare today. First I tried to add a map using regions. No dice. Then I pulled some recent crime data by district (because it was right in front of me) and SUCCESS! I was really happy. So I rolled my regions into districts, which were a better view anyway. I was lucky I had districts.

@MsNahualita 8 ай бұрын

I plotted the data the same, but it shows it on the "flat earth" map and not just the state :(

@chandoo_ 8 ай бұрын

🤫 Shh.. don't tell that to flat-earthers. On a more serious note, check if the state names have any invisible characters or spaces? Also try adding country column and make the chart.

@ashishsuman7079 Жыл бұрын

map is not showing in my excel ...pls help

@MsNahualita 8 ай бұрын

you might have an old version of excel. I had the same problem

@Jigyasaupadhyay1513 Жыл бұрын

I am worring chatgpt replace data analyst

@sammott8557 6 ай бұрын

Why isn't each city name showing in your Ohio map? I want my city names to show. How do I do this?

@MrReachavm 3 ай бұрын

Is there a way to make a map using zip codes?

@chandoo_ 3 ай бұрын

I don't think they are possible at this time. Zipcodes are not technically areas. They are postal delivery zones. So it is possible for one side of a street to have one zip code and the other side a different code.

@MrReachavm 3 ай бұрын

@chandoo_ thank you:)!

@Titannurse Жыл бұрын

Is this customizable? Meaning can I create my own map? For example, a map of an acute care hospital unit? No reason why I'm so specific 😂

@chandoo_ Жыл бұрын

The built-in maps are not customizable. But if you have a floor plan or something and want to show occupancy rates, you can create the layout in Excel and use conditional formatting to show that. Takes a bit of work, but the results can be beautiful. See this for an example - chandoo.org/wp/customer-satisfaction-scorecard/

@Titannurse Жыл бұрын

@@chandoo_ thank you chandoo. Love your channel