Make excel map data visualization, you won’t, colleagues can do it in 2 minutes, the gap is a bit big

2020-08-03 11:54:33 0 Comment 267 views
abstract

The function we are going to use today is a three-dimensional map. The three-dimensional map is actually a powermap, but it is called a three-dimensio

Hello, everyone, today I will share with you how we can visualize data on the map. The function we will use today is a three-dimensional map. The three-dimensional map is actually a powermap, but it is only after the 2016 version. The version is called a three-dimensional map. Powermap is one of the components of powerbi. It is mainly used to perform operations on data with geographic locations. The operation of visualizing map data with powermap is also very simple, and it can be completed with a click of a mouse. Very simple

Make excel map data visualization, you won’t, colleagues can do it in 2 minutes, the gap is a bit big

First, insert a three-dimensional map

Firstly, we select the data to be loaded into the 3D map, then click Insert, find the 3D map, choose to open the 3D map, and excel will automatically enter the 3D map interface

Make excel map data visualization, you won’t, colleagues can do it in 2 minutes, the gap is a bit big

Two, place fields

In this interface, we can select what we want to make in the graph below the data Chart type, here are a total of 5 chart types to choose from, and then we need to place the field in the appropriate position in the data below

The position is the field where the city is placed

Height is generally a field for numerical values

Category is the field we want to classify, and different categories will be filled with different The color of

The four arrow keys and the plus and minus signs below are used to control the direction and size of the map

Make excel map data visualization, you won’t, colleagues can do it in 2 minutes, the gap is a bit big

For example, we choose a stacked column chart and place the city in the location Field, put the sales volume in the height field, and continue to put the city in the category field. Here, the city is used for positioning, the sales volume is used to set the height of the column chart, and the sales volume in the category is the column for different cities The map is filled with different colors, so a simple map dataThe visualization is complete

Make excel map data visualization, you won’t, colleagues can do it in 2 minutes, the gap is a bit big

How about it, this is no longer just a look Yes, it will be discarded as soon as you do it?

I am excel from zero to one, follow me and continue to share more excel skills

  • A+
Classification: game
avatar