EXCEL Tutorial: Introduction to Dynamic Chart Map

In this video you will learn how to create an interactive Excel Chart Map.
Don't worry if you have never created a Chart Map before, I cover the basics of creating your first Table and utilize name definitions.
Reply to the video for further clarification or request other tutorials!

Download the file to follow along at the following link.

Reply to the video for further clarification or request other tutorials!

[rajasekar]

Wow. thanks for the tutorial. I will try myself😊👍

[BasitAbbasi]

Mother Russia appreciate your efforts. Thanks comrade

[firasmusmar]

When I try to define the series in select data source, but it gives error .. why?

[daniwiguna]

this tutorial is very useful and also very powerful to convincing our viewers on our presentations.... thanks so much

[amedeo]

Hello! Useful and interesting, Thanks.
I have EXCEL 2016 but no Map Chart feature - it seems that one needs to have the complete Office 365. Is that right? Any alternatives?

[alexkinyua]

Hi. I've tried this process several times but I keep getting stuck. I type the OFFSET and COUNTA functions exactly as you do but I get errors. Is it possible you show the full dialogue boxes especially when finalizing the MAP. Thank you

[himeshpatel]

Hi! Great video!
Can you please explain how can I add two data (in your case let's say oil production and consumption) in the map? Thanks!

[TugceOzbay]

Hi, this is very interesting thanks for sharing it. I'm getting the error message "data is too large" in the select data option. I just wanted to revise it by cities which are 81 currently in my country. Could you please support me how to fix this? Thanks

[mengl]

wow extremely useful. Thanks for uploading this

[dadgau]

Thanks for this tutorial, it sounds very useful

[robertocitarella]

Ciao ScuolaTech, una domanda: come mai pur selezionando "Europa" dallo slicer nella mia mappa sono comunque presenti tutti i continenti? Grazie in anticipo

[larsmaldonado]

How can I change the data for a country and add or delete countries and regions?
I want to show all countries in the regions of Canada, North America, Central America, and South America.
I also want to be able to show different places in a country -let's say I have 5 sites to service in Mexico.
How can I do this? Is there a day=ta chart missing where I can make those necessary changes?
Please send me your Email if possible. Thank you. Lars

[ExcelDose]

I tried the same but I feel it is more easy in Google Sheets as compare to Excel

[satrioprianda]

do you have any idea wy my excel dont have filled map on INSERT option ? instead it only offers the 3D map . i dont know why, maybe yall been thruu the same ???

[chicagomike]

Think finding a cure for cancer is easier than this.

[sammerfam]

How did you get the list of countries to begin with?

[ahmedal-dossary]

This is an extremely powerful tool. Can we show name of country on map instead of number?

[danielogipl]

which excel is that? pls answer me quick

[venkyvi]

i AM GETTING THE ERROR WHEN I TRY USING OFFSET FORMULA??

[fabiyijohn]

Please can someone help with the full offset formulae asap?