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

This article introduces the knowledge of "how to use the bullet of the sparklines plug-in". Many people will encounter such a dilemma in the operation of actual cases, so 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!

The following is the bullet chart menu that opens the sparklines plug-in:

The following is a reference example of a bullet diagram in the official guidance document:

The first three red parameters in the function are necessary parameters of the function (can not be omitted: think about it, too, if you want to do this kind of performance evaluation index, you have to tell the chart your current situation (actual value), goal (target value) and value range in order to establish a complete performance evaluation system).

The following black parameters should be omitted (can be omitted) does not mean that you do not have to control when writing the function, but you do not have to enter parameters, but you still need to leave the corresponding parameter position blank (separated by a comma). )

The following is the specific meaning of each parameter and the chart elements to control:

Measure: degree, measurement, is your indicator variable that controls the darkest and thinnest bar in the bullet diagram.

Target: target, control the red vertical bar in the chart.

Maxi: the maximum range that controls the data display range of the entire chart.

Good, Bad: good and bad; control the range of indicators at the bottom of the chart, usually filled with very light neutral colors.

Forecast: forecast; the thinnest bar in the center of a chart used to compare with indicator variables and target values.

TickUnit: tick marks, shown in a short line at the bottom of the chart.

ColorScheme: color that controls the bottom good and bad of the chart, and the color of the three rectangular areas before the maximum.

Vertical: vertical axis, this parameter controls the direction in which the chart is displayed, and defaults to False, that is, horizontal. (commonly used level, it looks more comfortable).

The following is the complete syntax formula of the bullet diagram function: (if you are not proficient, you still need to open the function input box, if you are proficient, you can enter the whole syntax directly into the cell)

= bulletchart (D3, 85, 100, 80, 60, 83, 10, 9868950)

Let's take a look at what happens when you change the Vertical parameter to True.

= bulletchart (D3, 85, 100, 80, 60, 83, 10, 9868950, true)

Sure enough, the effect is also very good, just to modify a parameter, this artifact is really clear, if you are in excel using built-in charts to do, it is estimated that you will be busy for most of the day.

After the first chart is completed, just as you populate the function formula in excel, the batch fills down the formula in the first chart cell.

A neat row of mini-field maps will be released.

As for the inverted bullet map (Reverse Bullet), I opened it and found that the syntax is the same as the ordinary bullet map syntax parameters I just did, but VBA reported an error when I ran after I lost the parameters, somehow.

Fortunately, we often use the chart in the ordinary (direction to the right) form of the situation a little more, the above explanation has been able to meet the needs of daily use.

This is the end of the content of "how to use bullet for the sparklines plug-in". 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.