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

This article mainly introduces "what is the Horizon of sparklines". In the daily operation, I believe that many people have doubts about what the Horizon of sparklines is. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "what is the Horizon of sparklines?" Next, please follow the editor to study!

The reason why it is a variant of the area map, because this horizontal map, the expression of information is almost the same as the area map, the difference is only in the form of the chart.

The horizontal chart places the positive and negative areas above the horizontal line, and cuts the area area into three parts on the vertical axis, places the three parts overlapping, and turns all the data areas into a horizontal band interval of uniform width. you can vaguely judge the size of the absolute value of each index by the color depth after overlap.

Its parameters are simple, with only four:

= HorizonChart (Points;BandHeight;ColorPositive;ColorNegative)

Points: this parameter is a required parameter and cannot be omitted. You can type a range of cells with positive and negative values.

BandHeight: this parameter is optional and has a default value. Customization requires setting an appropriate bandwidth value.

ColorPositive;ColorNegative: needless to say, this parameter is filled with positive and negative values like the area map.

The generation process of the horizontal chart is as follows:

Let's take a look at how to complete the production in the sparklines mini-chart menu of excel through the case parameter settings:

Through the filling of function formula, a group of horizontal lines can be obtained, and the relative size of the absolute value of positive and negative indexes can be roughly judged by the depth of color overlap.

At this point, the study of "what is the Horizon of sparklines" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.