Look Who it Was Random video

Excel - How to Build a Tour in 3D Maps (formerly GeoFlow) in Excel - Episode 1654

3,106 views · Published 26 February 2013 · 7:57 · Indexed 30 September 2026

Channel: MrExcel.com · 2013 · Education

Watch on YouTube

Microsoft Excel Tutorial: Mastering GeoFlow: Setting Up and Using the Excel 3D Map Add-in.

Welcome to another episode of the MrExcel podcast. In today's episode, we will be diving into the mechanics of GeoFlow, a new add-in for Excel 2013 Pro Plus. In our previous episode, we introduced you to this cool new tool, but today we will be showing you how to set it up and use it effectively.

First, let's take a look at our data set. It's a smaller set compared to the one we used in the previous episode, with 218 libraries and their corresponding addresses, population, and projected book arrival dates. We obtained this data from the Azure DataMarket. To use this data in GeoFlow, we need to first add it to PowerPivot. This can be done by converting the data into a table and then adding it to the data model.

Once the data is in the data model, we can go back to Excel and click on the 3D Map option under the Data tab. This will open up the GeoFlow interface. The first step is to specify the geographic fields, which in our case are City, State, and Zip. GeoFlow will then retrieve the locations from Bing and plot them on the map. We can then use the county population as the height of each column to get a better visual representation of the data.

GeoFlow also allows us to add a time component to our data. In our example, we have the projected book arrival dates for each library. By adding this field to the time component, we can see the data points appear and spread out over time, giving us an animated view of the data. This feature is great for tracking the progress of a project or shipment.

We can also create a tour in GeoFlow, which allows us to zoom in and out of different locations and add scenes to our tour. This is a great way to present our data and tell a story with it. We can even add a theme to our map to label the locations and make them more visually appealing.

Overall, GeoFlow is a fantastic tool that I am in love with. It's currently in beta, but I have high hopes for its final release to the public at the end of 2013 or early 2014. So if you have Excel 2013 Pro Plus, be sure to give GeoFlow a try and see how it can enhance your data visualization. Thanks for tuning in to this episode of the MrExcel podcast, and I'll see you next time for another informative netcast.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Intro to 3D Map
(00:15) Setting Up Data for GeoFlow
(00:33) Obtaining Data from Azure DataMarket
(00:51) Adding Data to Data Model
(01:07) Specifying Geographic Fields
(01:22) Choosing Geographic Fields for GeoFlow
(01:40) Mapping Data in GeoFlow
(02:05) Fixing Street Address Field
(02:19) Displaying Data Points
(02:43) Using County Population as Height
(03:01) Adding Category Field for Color
(03:42) Creating a Tour
(04:06) Adding Scenes to Tour
(04:38) Playing Tour
(05:25) Time Component in GeoFlow
(05:47) Using Date Field for Time Component
(06:09) Explanation of Time Component Options
(06:38) Temporal Accumulation Option
(06:48) Illustration of Time Animation
(07:28) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excel3dmap #excelmaps

This video answers these common search terms:
how to make a tour on 3d map excel
how to create a geographic heat map in excel
how to make an excel geographic map
how to create 3d map in excel
how to make a 3d map in excel
how to use 3d map in excel
how to embed 3d map in excel
how to create a geographic heatmap in excel

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153476/

Yesterday Bill introduced us to the new GeoFlow Add-in, coming soon for Excel. Today in Episode #1654, Bill gives us an Introduction to how it works and how we can work with it!

More from this channel