Detailed steps for making a business-like bullet chart from Excel table data

1. The data usually needed to make bullet charts include different levels of evaluation baselines, target baselines and actual achieved values, as shown in the figure below.

2. Select all the data in the previous step, [Insert - Column Chart - Stacked Column Chart], and you will get the chart shown in Figure 1 below. The data in this chart is reversed in rows and columns. You need to use [Design-Switch Rows/Columns] to get the stacked column chart shown in Figure 2 below.

3. Set the target baseline. The target baseline is achieved by removing the connecting lines from the line chart. Select the data mark in the shape of a horizontal bar for the data mark. As shown in Figure 1 below, first generate a line chart, then select the line chart data, set the style of the data mark (Figure 2), and set the connection to [No Line] (Figure 3).

4. Select the actual achieved data, as shown in Figure 1 below, select the series to draw on the secondary axis, and adjust the classification spacing to 435% to form the basic structure of the bullet chart .

5. Adjust the minimum, maximum value, and scale unit of the secondary vertical axis to be consistent with the main vertical axis. This will basically complete the prototype of the bullet chart. Delete it after the adjustment is completed. The secondary ordinate axis results in the following figure.

6. The subsequent step is the beautification process. You can set the fill colors of different levels to the same color system (for example, the gray and black color system set in this example). The actual data is set to be more eye-catching. The color (such as orange in this example), the target data is set to a striking contrasting color (such as red in this example), and finally the position of the legend is adjusted to above the chart, and the following picture can be obtained after adding a title.

The above is the detailed content of Detailed steps for making a business-like bullet chart from Excel table data. For more information, please follow other related articles on the PHP Chinese website!