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

The original title: "Why is the mother cake chart made by colleagues with Excel so beautiful?" "

Hello everyone! I am Green Water Zero.

Recently, a colleague found a problem when he was working on a sales performance chart.

Because the sales volume of different categories of products is relatively different, the lower positioning of grade 1 to 3 products have 4 digits, but the total sales of high level 4 to 6 products are much smaller, only 3 digits.

Therefore, in the pie chart, the proportion of Grade 4 to 6 products is too small to see clearly at all. He wants to know if there is a more suitable chart that can solve this kind of problem.

Of course there are ways.

We regard grade 1, 2 and 3 products as large sales products, level 4, 5 and 6 products as small sales products, because the difference is relatively large, it is not appropriate to use the same measurement unit.

When using histograms and diagrams, we can deal with them by setting up secondary axes.

In the pie chart, we can use the compound pie chart, also known as the sub-mother pie chart, for processing. (the sub-pie chart is equivalent to setting up another secondary axis. )

In the above case, making a composite pie chart is like the following picture!

Let's see how to do it.

PS. The following case is demonstrated using the WPS table

Composite pie chart ▋ STEP01 collates the data source composite pie chart is to summarize the categories at the end of the data source into another category, and draw another pie chart (that is, the second drawing area).

Therefore, before drawing the chart, we need to do a simple preprocessing of the data.

For example, in this case, we want to put the data of levels 4, 5 and 6 at the end.

▋ STEP02 insert compound pie chart ❶ select the data source (including title), click the "insert" tab, and select "all Chart".

❷ select compound Pie Chart in Pie Chart, and click the illustration preset chart.

▋ STEP03 format Chart ❶ double-click any element in the chart to quickly open the properties window and format the chart.

❷ select any sector in the pie chart, click [Series] in the series options, and set the series division by-[value in the second drawing area] to 3.

[values in the second drawing area] represents the number of categories in the second drawing area, which is the number of categories from bottom to top in the data source, and the default is 2.

Our goal is to draw a pie chart consisting of levels 4, 5 and 6 in the second drawing area, so the value is set to 3.

▋ STEP04 beautify the chart ❶ delete the chart title, draw a rectangle, double-click the rectangle to set the properties, set the color to green (RGB:22124127), and set the line to wireless bar.

❷ insert text box to enter title content, select Chinese text box to set text box properties, click [text options]-[fill outline], select solid color fill, color choose white, text outline is set to wireless bar.

❸ selects the entire chart, sets the background color, and selects each series separately to set the series color. If you want to use the color matching of the case, you can copy the case picture directly to the table, and then use the color picker to pick up the color.

The ❹ settings legend is on the right side of the chart.

❺ adds data labels.

❻ selects the other series (the gray sector), sets the property, and sets the point explosion value to 38% (the higher the value, the greater the displacement from the other sectors).

Take care of ↓↓↓

At the end of the composite cookie chart, let's not talk about practical information, let's ask you a small question to relax:

How many people misread the title of this part and think it is repeated with the "compound pie chart" of the first part?

In fact, what we are going to talk about here is another kind of pie chart-compound pie chart.

It's niche, but it's also practical.

We can also use it to show the case above.

The operation and setting method is the same as the compound pie chart, you only need to select the compound bar pie chart when inserting the graph.

Another common scenario written at the end of the composite pie chart is for data presentation with two subordinate levels.

For example, in the following picture, the master cake chart on the left shows the sales of each store, and on the right is the sales of each salesperson of store D.

In fact, the application scene of each kind of combined graphics can be adjusted according to the demand, arouse your imagination, and you can see the figure of the composite pie chart in other places.

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: green Water Zero, 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.