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

This article mainly talks about "what is the HVar and VBar of sparklines". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next, let the editor take you to learn "what is the HVar and VBar of sparklines?"

A single bar / column chart in the Comparision chart type.

The bar chart referred to here is called a single bar chart or column chart because each data bar or column is stored in a separate cell, rather than the entire chart as previously done.

The syntax for this chart type is very simple, with only two parameters:

= VBar (Value;ColorScheme)

= HBar (Value;ColorScheme)

The first variable is the column chart and bar chart data area, and the second parameter is the color area. (where V and H represent column chart and bar chart respectively).

In the column chart, the negative value chart is facing down, and the bar bar is facing left.

Here you can see that if the function syntax is not adjusted, it can be made that if there are negative values, the positive and negative data bars are separated at both ends and cannot be compared.

Therefore, you need to combine the built-in functions of excel for flexible configuration:

= IF (E4 > 0) Hbar (E4) 2112496), ")

= IF (E4 > 0, "", hbar (E4pr 3631104))

As long as two sentences of if functions are nesting flexibly, you can solve the problem that the charts can not be aligned.

If there is a negative value in the column chart data source, it can also be flexibly handled by the if logic judgment function:

= IF (A12 > 0) VBar (A12 > 1841891), ")

= IF (A12 > 0, "", vbar (A12pr 4424739))

At this point, I believe you have a deeper understanding of "what is sparklines's HVar and VBar". 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.