Microsoft Office Tutorials and References
In Depth Information
5. Extending Excel with Excel Apps and Add-Ins
Figure 5.8.
Figure 5.8. California and Texas have the highest values in the data set.
California and Texas have the highest values in the data set.
This app works great on your computer because you have the app installed.
What if you need to distribute the map to others who might not have the app
installed? Open the drop-down in the top right of the map and choose to save
as an image.
The one problem with the Geographic Heat Map is that you have to summarize
your data by state. This takes a few minutes and a pivot table to produce
the summary. What if you are not comfortable with a pivot table? You could
turn to Chapter 23 , Using Pivot Tables to Analyze Data , for a quick in-
troduction, or you can look for other apps.
In Figure 5.9 , the Bubbles app took the unsummarized raw data, did the consol-
idation, and created an interesting bubble visualization. Click any bubble to
have the values appear.
Search JabSto ::




Custom Search