Excel Heat Map Chart Fast & Easy | State + Zip | Postcode + Country | Australia + Indonesia + World

Create Excel map chart by state, region, province, county, zipcode, postcode with ease... No need for latitude & longitude...

Hi every one,

There is now an easy way to create a heat map chart in Excel.
This is something that I recently learnt this year and very excited to share this with you.
Hope this video will make your life easier.

There is a special section in the video - whereby I'll show you how excel can create map chart with Indonesian language as an input. Yes, you can enter "' Propinsi dalam bahasa Indonesia " and Excel is so smart that it is able to convert that into a map chart.

There is a small catch, you need to be connected to the internet and you need to be using Excel 365.

Cheers,
Isabella Susilowati.

#MapChart #ExcelTips #LighthouseAnalytix

Time Stamps:

00:00 Introduction
00:23 Four Types of Map Charts
01:14 Map Chart by State / Region / Province
02:45 Map Chart by Postcode/ Zipcode
04:24 Map Chart in Other Language
06:21 Map Chart by Country
07:47 Recap
08:01 Caveat
08:21 Two special tips
08:58 Epilogue

LA21

[TopleftdesignsAu]

You will not believe how much effort I have put into finding a web service to plot postcode locations and here you are showing me how to achieve this in minutes... best ever new lesson. Thank you

[AidanJohnson]

An amazing video, thanks so much for sharing in such a simple and easy to understand way

[robertzendzian]

This is awesome. Thank you for sharing!

[ChrisBongorno]

SUPER helpful! I really enjoyed the video and have shared it with with several colleagues!

[swiftlaker]

Thank you!! I was looking through so many tutorials and add-ins and here it is just built in! :D

[jdae]

I love your video. It Works for Equador (Ecuador - Spanish)

[GSHYTbullet]

Thanks, Is there a way to map UK postcodes? it seems they don't get recognized by excel as a map item

[Bhavik_Khatri]

Hi, Could you please share this excel file?

[PremierBuyers]

Would you know if a similar feature is available for suburbs?

[albertrobbins]

Just wondering if there is a way to get plot a map of Electoral Distrcits & Regions for an Australian state (Effectively smaller than State by state, but larger than postcode by postcode. Cheers, Albert

[rootdee]

Thanks for the video. Can we create regency/kabupaten in Indonesia's maps? I couldn't create it.

[eileenyap]

Hi could you advise me how do i get APAC regions only in excel map? when my data has APAC regions listed, it will show the world map

[Baden-ez]

Is there something wrong with Western and Southern Australia? When trying to filter down on postcodes in these states, the automatic view of the map area (under series options) doesn't work correctly for me. The map zooms out to a global view, when I just want to see a zoomed in view of West Aus :(