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

This article mainly talks about "what is Columns in sparklines". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "what is Columns in sparklines"?

In the final analysis, the chart is actually the most commonly used bar chart in our daily work.

The chart has more function parameters, a total of 15, but many elements are not suitable to appear at the same time, here we will generally use about five or six effective parameters.

With regard to the specific meaning of each parameter and the chart elements controlled in the chart, it is clear in the above illustration that the red parameter is a necessary parameter (indispensable). Other parameters are optional or have default values.

For the overall aesthetics of the chart, this highlights several parameters:

Points: this is a required parameter, which is the input cell range of the indicator.

Mini,Maxi: the boundary of the minimum and maximum values, that is, the range of the ordinate axis of the chart.

Line1,Line2: these two are the reference lines of comparison between high and low values. They are used for comparison and have no practical significance.

ColorPositive,ColorPositive: positive and negative values show the fill color, these two parameters had better be set, set to the contrast color of the project, easy to distinguish by color.

Other parameters do not feel meaningful personally, so you can explore them if you are interested.

The following is the function menu input in Excel:

Also through the function formula filling, you can do a batch of drawings to form a set of mini-graph reports.

At this point, I believe you have a deeper understanding of "what is Columns in sparklines". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.