Learn Excel 2013 - "Choropleth Heat Mapping in GeoFlow": Podcast #1703

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on May 6, 2013.
He may not be able to spell Choropleth... but he can tell us about it! After Bill's latest week-long series centering on Microsoft GoeFlow, using Real Estate and Property locations [to find a Home in Florida, USA], a question came in about Heat Mapping. Today, in Episode #1703, MrExcel addresses 'Choropleth' Heat Mapping with the current Beta version of Microsoft GeoFlow.

[youtube=[MEDIA=youtube]-7jKj3tXoNU[/MEDIA]]

And for more information on Excel 2013, check out "Microsoft 2013 InDepth" -- by Bill Jelen. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2013. Amazon.com: Excel 2013 In Depth (9780789748577): Jelen, Bill: Books

"The Learn Excel from MrExcel Podcast Series"

Visit us: MrExcel.com for all of your Microsoft Excel Needs!
maxresdefault.jpg


Transcript of the video:
MrExcel podcast is sponsored by "Easy-XL"!
Learn Excel from MrExcel podcast, episode 1703 - Luckily, I can't even spell Cloropleth!
Alright well hey, a few weeks ago I showed GeoFlow, that new preview for Excel 2013, and someone said "Hey, show us the heat maps!" Alright, so at that time I showed the Column chart, it was the real estate down in Florida, we'll take a look at the other two types here.
The Bubble chart, where every point is represented by the size, this is GDP, and then the HeatMap!
And the question was "Does it do a Choropleth HeatMap?" That's whether you color in the entire range of the state with the color.
And no, it does not do that, the GeoFlow team knows that this would be cool.
I probably last saw this back in the days of MapInfo Pro, very expensive mapping solution.
So right now GeoFlow does not do the heat maps, where they color in the whole state.
This data looks a lot better when you have lots of data points, sort of like in this real estate data that we did in the last one.
So let's change this from a Column, Bubble, with the bubbles just be way too large, wouldn't be able to see anything.
A heat map, eh yeah, alright.
Well there you go, that's what we have with the HeatMap.
Again remember, this is a project code-named GeoFlow, it's just in beta right now, the final product will, be perhaps a bit different.
So does it do Choropleth, HeatMaps?
No it doesn't, this is what we have.
Why hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
 

Forum statistics

Threads
1,213,557
Messages
6,114,291
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top