Office hacks: Flat to 3D – GeoFlow makes Excel come to life

201816geoe1

Figure 1 Example data

We know that 3D data has a very intuitive visualization effect, but the default in Excel can not directly generate 3D data. If you want to make your data 3D, now you can do it with GeoFlow (support Excel 2013) plug-in. Because GeoFlow is to convert flat data into 3D map display, it is best to choose data that is easy to display on the map. Below is the sales data of a cell phone in different country regions, and this data can now be displayed visually on a map in 3D (Figure 1).

Go to http://uee.me/ajqzX下载所需的插件 and the add-in will be automatically integrated into the Insert menu of Excel after installation. Select the country and sales quantity data in Excel, switch to “Insert” and click on “MAP→ADD select data to GeoFlow” to start the add-in (Figure 2).

201816geoe2

Figure 2 start plug-in

The default launch is a binging earth shape, and in the right pane is the data structure detected by the system. Select the Country tab, then make sure this field is selected as Country type. Then click on Map It and we can see that the data points of the corresponding city are already marked on the globe icon (Figure 3).

201816geoe3

Figure 3 City data is marked

Because the sales data is a cluster of data, here we have to set the Height of the right pane (that is, the shape displayed on the map) to “stacked”, so that the original flat data displayed in Excel will automatically become the data on the 3D map, and we can drag the region to visualize the sales of each country We can drag the region to visualize the sales data of each country (Figure 4).

201816geoe4

Figure 4 View sales data in 3D

As you can see, with the GeoFlow plug-in, we can easily transform the data in Excel into a bing map. For data such as regional sales, market share, and geographically relevant data, it is very intuitive to translate into 3D data through the plug-in. Of course, if these eh data need to be displayed on other tools, such as the transfer to WeChat, QQ, we just need to zoom in on the map display in Excel, and then through the screenshot tool can easily convert it into a picture to share (Figure 5).

201816geoe5

Figure 5 Screenshot display

Leave a Comment