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...
by Nate Moore | May 9, 2016 | Excel 2016, Maps
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...
by Nate Moore | May 2, 2016 | Excel 2016, 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...
