Shulou(Shulou.com)11/24 Report--

The original title: "the line chart you made is too Low, this is the data analysis chart of NO.1!" "

Hello, everyone. I continue to study the cool of all kinds of charts.

Ask everyone, which charts will you choose to show the following three scenes?

The recent changes in the ranking of monthly sales in a certain group of ❶

A variety of ❷ products, heat comparison in a recent period of time

❸ different sales staff, in the whole year's sales situation comparison.

The first thing we think of is a line chart, because it involves a time dimension.

Let's take the monthly sales comparison of the group as an example.

👉 makes a line chart as shown in the following figure:

The standard line chart, though, clearly shows the trend of the group's sales.

But even if we have highlighted Group C, there is no way to see the change in the ranking of Group C.

What if we change the line chart into a bump chart?

In the bump chart, the x-axis continues to represent the time dimension and the y-axis represents the group ranking dimension.

👉 is shown in the following figure:

From the picture, we can clearly see the recent ranking of Group C:

Group C rose from January to March, but dropped to fifth place in April.

Sometimes, when the ranking of things is more important than the actual value, we can try to use bump graphs.

A bump chart is a deformation of a line chart.

At this time, some friends are curious, what is the chart of the bump chart, and how is it made?

What is it? The bump chart can directly see the changing trend of ranking, and it is often used to compare the ranking changes of different categories.

It usually takes two dimensions to make a bump chart, one measure:

❶ dimension: change trend (common time dimension); category of ranking

❷ measure: the value used for ranking calculation (e. G. sales, popularity, etc.).

Bump diagrams work well because they make the rankings clearer, but they also hide the actual value of the data.

If you have to present the actual data, there is a way to save the nation by using the corresponding measure as the data label directly in the bump chart.

Now that we know what a bump is, let's take a look at how it is done in Excel.

How? The method of making 👉 bump graph:

The first step of ▋: make a ranking table and enter the formula in the B21 cell and fill in:

= RANK (B2, F2)

▋ step 2: insert Line Chart Select [insert] tab-Line Chart-insert Line Chart.

The third step of ▋: beautify the chart, highlight the broken lines of group C except for group C set to "gray" and "thin lines", so that the broken lines of group C are highlighted.

Tip: we can click the corresponding line chart and set it by clicking the drop-down list under the format tab.

Step 4 of ▋: add tags and data tags ① sets the tag option type.

Select the C group tag, right-click [format data Series]-Select the "fill" icon

Click "tag"-"tag options"-"built-in", the type is "○", and the size can be set according to the actual situation.

The dynamic picture is as follows:

② adds a data label with the location set to Center.

Step 5 of ▋: set the ordinate to reverse the scale mouse over the ordinate axis-right-click [format axis]-check "reverse scale value".

▋ step 6: set the Abscissa "label position" to "high"

Finally, delete the grid lines, and the bump graph is almost complete.

How to use it? Where can I use a bump chart?

For example:

To track the popularity of products, we can use bump charts to compare the rankings.

The weekly competitive ranking of each group in the training camp can also be compared with a bump chart.

……

Bump diagrams can also add interactive effects and click wherever you want!

For example: add data verification to link the chart, and we can see which group we want to see.

You can also add a check box to link the chart. We can compare which group we want to compare.

To sum up, this paper introduces a kind of deformation chart of line chart-bump chart:

❶ it is generally used in different categories in a certain period of time ranking changes

❷, its basic production method.

❸ its interactive diagram.

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Xiao Shuang, Editor: Zhu Lan

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.