A bullet chart is an improved version of the classic bar chart, designed to clearly show results in relation to a target. This widget was implemented in version 2.3.
A bullet chart is a type of bar chart used to visualize progress against a target. It consists of a main bar representing the current value, a background representing ranges of values (e.g., poor, average, good) and a line marking the target.
Properties
Band 1 - upper limit of the first interval on the chart
Band 2 - the upper limit of the second interval on the chart
Series - there is only one series in this chart
Name - this is the name of the series that will be displayed in the legend and in the label when you hover over a point on the chart.
Data - if the data comes from an external table or list, use the lookup formula to get the correct record (the first record that meets the search criteria will be linked). If the data is entered directly into the field or given as a cell address, you can leave the field blank.
Category - if a lookup was given in the “Data” field, use the column from the linked record in the formula. If not, provide the value or cell address. If the value is not specified, the category from the axis option or the default label will be assigned.
Value - If a lookup has been specified in the “Data” field, use the columns from the associated record in the formula to calculate the value. If not, specify the value or cell address.
Data bullet - determines the shape of the points on the chart.
Data labels - labels that help the user read the values on the chart:
- Tooltip - When you hover over a point on the axis, its value will be displayed
- Fixed - values are displayed directly on the chart
- None - labels will not be displayed
Target - the position of the marker marked on the chart. A more detailed discussion of this property can be found in the article - progress chart.
Example 1.
Suppose we want to show the progress of sales against the target for the first quarter of the year.
On our chart we have several key elements.
The performance ranges (bands) which, define sales levels. Band 1 has an upper limit at 30, which means that a result falling within this range is very poor. Band 2 ends higher at 60 and represents an average sales level. Above Band 2 is an area indicating a good score.
The current sales are 75% of the target, which means that our result falls in the zone between average and good levels, but has not yet reached the full target. We take the value from the cell address in the spreadsheet
The set sales (target) is 100, and it is marked on the chart as the benchmark we are aiming for.
With this kind of visualization, you can easily see that the result of 75% is well above the very low level, but has not yet reached the full target. This kind of chart helps you quickly assess the progress and effectiveness of your sales strategy in the first quarter of the year (Q1).
Chart properties
Bullet chart
0 Comments