by Nate Moore | Jun 20, 2016 | Excel 2016, 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...
by Nate Moore | Jun 13, 2016 | Excel 2016, 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...
by Nate Moore | Jun 6, 2016 | Excel 2016, Maps
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...
by Nate Moore | May 30, 2016 | Excel 2016, Maps
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...
by Nate Moore | May 23, 2016 | Excel 2016, Maps
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...
by Nate Moore | May 16, 2016 | Business Intelligence, Excel 2016
Excel Video 508 introduces 3D Maps Legends and Data Cards, two ways to give you users more information about your map. It’s easy to tweak settings on the Legend to change the font, font size, bold, italic, font color, and background color. There’s plenty of...
