How to use Excel to create 3D map chart in Win10 system?

Many users know that an Excel spreadsheet can be inserted into a chart to identify fluctuations in the data graph. However, these charts are all two-dimensional, and the visual impact is not strong. If you use a 3D map plus a chart, you can make the entire chart vibrant.

Procedure:

1, need not utilize the function, the calculation formula for statistical methods like, simply needs to display the field names, the data ready to record Yes.

2. Select the required data (including the field name) and click “3D Map” in the Insert ” tab demo area. Click the second button at layer 1 on the right side of the map editing window to rename the layer. Use the “text box” button on the toolbar to add a title to the data globe. Use the buttons that control the Earth in the edit window to adjust the display angle of the data globe.

3, next to the various scenes to be displayed. Click on “World Map" in the “New Scene" to add a new scene. Select this scene and rename the layer; at the location, click “Add Field”, select “Large City”, click the down arrow on the right side of the city, select “City”, “High” (“ Add field & rdquo;, the area is selected "sales", point to the right arrow down, select "average", "category point", add field & rdquo;, regional election "city". Finally, use the buttons that control the Earth to adjust the display angle of the data globe (Figure 4).

4. After the main scene is set, the design shows the sub-scenarios of sales in each county. Click on “New Scene" in the "World Map" to select the newly added scene and rename the layer; the location is "Add Field", the area is selected "District County", click The right arrow on the right side of the city, select “County and City”, “Height Point”, “Add Field”, select “Large”, click the right arrow down on the right side, select “Sum and Sum”. Category point & ldquo; add field & rdquo;, regional election & ldquo; district /rdquo;; click filter in the "add filter", select the region "city", check the desired city (such as Tangshan) . It is also necessary to adjust the display angle of the data earth.

5, the display of sales in other counties and districts, you can click on the "new scene" on the toolbar, select "Copy scene 3", set the method is the same as above, just choose different when filtering city.

In addition to the above functions, you can also place the mouse on the column chart to show the specific meaning of the column.