In this example, we will work on a sample data file named Dallas Utility Demo.xlsx
, which shows information of houses in Dallas, such as the size and year they were built. It also has information such as the KWH power consumed for the house. So, we use this source file to perform visualization of the data based on the year it was built and its power consumption by executing the following steps. You can download the file from the code bundle of this book:
Open
Dallas Utility Demo.xlsx
and have a look at the data rows. You will see geospatial information such as latitude and longitude, year built, condition, and kwh power consumption.Go to the Insert tab in Excel, and under Map, select Launch Power Map, as shown in the following screenshot (if you cannot see this option, download and install Power Map for Excel 2013 from http://www.microsoft.com/en-us/download/details.aspx?id=38395):
In the Launch Power Map dialog box in the bottom-left corner...