How Excel makes three-dimensional data maps

Source: Internet
Author: User
Tags final

use ordinary charts for product sales demo, visual impact is not strong. If you use the 3D map to add a chart, it will give a refreshing feeling. You might think the process is too complicated. In fact, using Excel 2016 makes such an effect easy (Figure 1).

There is no need to use computational statistics such as functions, formulas, just the need to display field names, record data ready to do (Figure 2). Select the data you want (including the field name), and click the "Insert" tab to show the "three-dimensional map" in the area. Click the 2nd 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 caption to the data earth. Then use the edit window to control the Earth's button to adjust the data Earth's display angle (Figure 3)

Next, make each scene that you want to show. Click on the "World map" in "New Scene" to add a new scene. Select the scene, rename the layer, and place the Add field. Regional Office Select "City", Point City right down arrow, select "City"; point "add Field", regional department select "Sales", point sales to the right down arrow, select "Average"; Finally, use the Control earth button to adjust the display angle of the data Earth (Figure 4).

After the main scene setup is completed, the design shows the distribution scene of each county. Click on the "World map" in "New Scene" to select the newly added scene, rename the layer; Place at the point "Add a field", the regional department select "County", click on the city right down arrow, select "Counties and cities"; height point "add Field", regional department select "Sales", click on sales right down arrow, select "Sum"; Categories at the point of "add fields", the regional department selected "county"; Click Add Filter in the filter, select City, and select city (such as Tangshan). Also need to adjust the data Earth's display angle.

Other cities in the county sales of the display, you can click on the toolbar "new scene" select "Copy Scene 3", set the method above, only in the selection of different cities. Excel Tutorials

After all the scenes have been added, click "Play Demo" to play the final effect. You can also output the final effect as a video file.

Small Tips

During the demo, the mouse is placed on the column chart to show the concrete meaning of the column.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.