Shulou(Shulou.com)06/01 Report--

How to use excel to save the appearance of the chart, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

I just thought the chart was a little cute and fresh, so I couldn't help writing it. In fact, the technique used was the piling up of the detailed skills I talked about before.

The case diagram is as follows:

The core skills used are still:

Timescale + stacking area chart + staggered organization data + scatter chart auxiliary column (add label)

The following is the idea of organizing mapping data:

The original data obtained should be converted into cumulative sum data (that is, data with a sum of 100)

By observing the segmentation points of each layer of color blocks in the horizontal direction of the stacked bar graph (the auxiliary sequence in the middle is also calculated), the values of all the segmentation points are obtained and arranged in order.

The same group of business data is arranged in the order of business indicators (not by size), while the two groups of indicators need to be arranged in the order of data size (that is, the order in which different levels of segmentation points appear).

With the exception of only one index for the first and last points, the intermediate points need to appear in pairs (to facilitate stitching the breakpoints by timescale).

What needs to be noticed here is that in the 610 columns, why the first four columns rise step by step, while the last column of data goes to the bottom. Here, it is determined according to the direction of the section line of the auxiliary sequence in the original picture. The first four section lines are all facing the lower left corner, and the last one is toward the lower right corner. If it rises step by step in order, the last section line will go down to the left instead of to the lower right. This deviates from the original picture. (you can feel the difference through your own time when you get the source file.)

Select the mapping data and insert the stacked area map (excluding the first row and first column).

Right-click to open the Select data menu and specify the horizontal axis label option data source as the first column. (B7:B24)

Open the X axis menu setting option and change the axis type to the date and time scale.

Remove unnecessary redundant elements and add text and comment information.

For information about data labels, the method described here is still to use scatter plot auxiliary labeling:

The data are as follows: (for the X-axis position of the scatter point, you need to calculate the position manually, which can be realized through the function)

I34=SUM ($H$33:$H33) + H34bind 2

# the above are only the first line of cell functions, pay attention to the absolute reference and relative reference.

After the addition is complete, you need to manually change the two newly added sequences to scatter plots and assign them the correct X-axis and Y-axis coordinates. Then use tags to add work, adding data tags to each of them. (I am using XY Chart Labels)

Do some fine-tuning and beautification, and the final effect of the chart is as follows:

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

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.