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

This article introduces the relevant knowledge of "what is the Cascade of sparklines". In the operation of actual cases, many people will encounter such a dilemma. Then let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Composition (Cascade).

I don't know why the name of this picture looks so strange in English, but it is actually the waterfall we shared before.

The waterfall chart is used to deconstruct a variety of positive and negative influencing factors, showing the direction and size of each factor in the overall influencing factors of a certain index. (note that it is different from the Pareto diagram in the previous article)

In the parameter diagram shown above, PointsRange refers to the data input range of the waterfall diagram, and LabelRange is the label shown in the chart (a range of cells consistent with the data range).

Min,Max: refers to the positive and negative boundary of the horizontal axis (vertical axis) axis of the waterfall diagram.

ColorPositive,ColorNegative: positive and negative indicator fill color.

The following are the function parameter input steps for making the chart in excel:

It is important to note that the last row of values is the summary value, that is, the cumulative sum of all the previous values, both positive and negative are counted separately.

Similarly, the chart is the same as the chart mentioned above, the function can automatically judge the nature of the rows and rows of data, so as to produce the corresponding vertical chart and horizontal chart.

Convert the above data into row data, enter the same parameters or formula again, and the chart immediately becomes horizontal.

Look carefully you will find that in the chart, although only enter two colors (positive and negative two color parameter values), but the resulting chart will automatically assign color hue according to the nature of positive and negative values and the size of absolute values, this is also the strength of this software, I have to admire the VBA writing team behind is to understand the needs of chart producers too well.

The following cases can be used as examples of exercises, and those who are interested can have a try.

This is the end of the content of "what is the Cascade of sparklines". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.