Select Page

Excel Video 519 Time and View Options in 3D Maps

We will cover the ribbon sections for time and view options in 3D Maps in Excel Video 519. Once you add a time element to your map, Excel Video 519 will show you how to tweak the timeline and the way the time is displayed. Showing seconds in the time display when your...

read more

Excel Video 518 Insert Options in 3D Maps

There are three Insert Options in 3D Maps to discuss in Excel Video 518. You can insert a two-dimensional chart that displays the same data shown on your map. You can choose either a column chart or a bar chart and can choose whether or not the chart is stacked, but...

read more

Excel Video 517 Map Options in 3D Maps

Excel Video 517 has three ways to add map options in 3D Maps. First, there is an easy way to add map labels like names of cities to your map. The Map Labels button toggles the names on and off. Map labels can be especially helpful if you are trying to understand...

read more

Excel Video 516 Videos and Themes in 3D Maps

We have spent a lot of time getting just the right data on our map, so today Excel Video 516 takes a few minutes to think about using videos and themes in 3D maps. Remember that this is Excel, not a movie-producing software package. There are, however, some things we...

read more

Excel Video 515 Scene Options in 3D Maps

Happy 4th of July, everyone! I hope you enjoyed the long weekend. In Excel Video 515 we will play a Tour and change some Scene Options relating to how the Tour is presented. A Tour is simply a collection of scenes played in the order we set in Excel Video 514. The...

read more

Excel Video 514 Scenes in 3D Maps

Excel Video 514 demonstrates scenes in 3D Maps. A scene is a view of your data on a map. Layers allowed us to put multiple sets of data on the same map. Today we can use scenes to put multiple sets of data on different maps. Watch how we can create a new scene based...

read more

Excel Video 513 Layers in 3D Maps

Now that Excel Video 512 has given us multiple datasets to play with, we will use layers in 3D Maps to show multiple sets of data on one map. To keep things simple to start with, watch how I use the eye icon to hide the CMS Referrals Data layer. We can then work with...

read more

Excel Video 512 Multiple Datasets in 3D Maps

To add more features to our discussion of mapping in Excel, we need to add Multiple Datasets in 3D Maps. Excel Video 512 will do just that. Our objective to is plot different sources of data in one tour, or group of maps. For example, we won’t just track referral...

read more

Excel Video 511 3D Maps Region Map

A region map is a great way to see your data summarized by geographic region, like a zip code. Watch Excel Video 511 to see how to make a region map work for your data. The first thing to note is that unlike heat maps, a region map will let you use categories with...

read more

Excel Video 510 3D Maps Heat Map

Excel Video 510 uses 3D Maps to build a Heat Map in Excel. Instead of column height or bubble sizes, a heat map changes colors based on the value of the data. By default, lower values have cool, blue colors. As the values increase, the color of the heat map...

read more

Excel Video 509 3D Maps Bubble Chart

We’ll create a 3D Map Bubble Chart in Excel Video 509. Before we get started on new chart types, watch for a brief explanation of Excel and Bing’s attempt to quantify the mapping accuracy of your geographic data. If you have common names like Washington for a city or...

read more

Excel Video 507 3D Maps Categories and Colors

We’ll add 3D Maps Categories and Colors in Excel Video 507. A category simply splits the data into columns in our map. Instead of looking at a summary of patients referred to other providers, moving the Hospital or Provider field into the Category area allows us to...

read more

Excel Video 506 Filtering in 3D Maps

Excel Video 506 introduces filtering in 3D Maps. I hope you’ll be pleasantly surprised at the variety and flexibility of the filtering options available. You can manually filter items as you’d expect, but filtering in 3D Maps also has advanced and/or functionality as...

read more

Excel Video 504 Power View Maps Part 2

Now that we have covered the basics of creating Power View Maps, Excel Video 504 adds several more features you might find helpful. Watch how adding a field to the Colors area turns the bubble points on the map into pie charts. Now you can see the number of patients...

read more