Bullet Chart

1) Bullet Chart is a refined type of bar graph, designed to enhance comparisons across multiple levels and to facilitate the visualization of performance against predetermined targets. Crucially, bullet charts condense complex data into a compact, easy-to-understand format, which is highly beneficial in performance reviews and strategic planning. 

2) They are particularly advantageous in business and finance, offering clear snapshots of progress towards goals, thus aiding in efficient decision-making and reporting. The simplicity and clarity of bullet charts make them an essential tool for data presentation where space is limited and precision is necessary.

3) Application Scenario：It can compare the Contract Amount and Payback Amount of different years, or compare the Contract Amount and Payback Amount for each year.

Data Preparation

1. Click My Analysis, click a folder, and click New Subject.

2. Click Local Excel and click Upload Data, as shown in the following figure.

You can download the sample data Regional Data Analysis.xlsx.

3. Convert the columns Contract Amount and Payback Amount into rows.

4. Rename the converted fields and deselect fields that are not needed for analysis.

Chart Creation

1. Create a component, click the Custom Chart icon, drag the field Contract Signing Time into Horizontal Axis and Amount into Vertical Axis, and group Contract Signing Time by year.

2. Drag the Amount Type field into Color and Size.

3. Set the color opacity to 60%.

4. Customize sort for the Amount Type field in Size. Reverse the order of Contract Amount and Payback Amount, as shown in the following figure.

The columns of Payback Amount were wider, while after adjustment, the columns of Contract Amount are wider.

The following figure shows the created bullet chart.

Payback Rate Calculation

1. Copy the Amount field to generate the fields Amount 1 and Amount 2.

Click the dropdown icon of Amount 1, click Filter Detail, and set the filter condition that Amount Type is Contract Amount.

Click the dropdown icon of Amount 2, click Filter Detail, and set the filter condition that Amount Type is Payback Amount.

2. Create a calculation indicator named Payback Rate.

3. Drag the Payback Rate field into Vertical Axis, click the field's dropdown icon, and click Set Value Axis. Select Right-value Axis, and set the maximum axis scale value to 1.

4. Select Line for Payback Rate in Graphic Property.

5. Drag the Payback Rate field into Label under Payback Rate and set Value Format to Percentage.

Effect Display

For details, see section "Overview."

In conclusion, Bullet Charts are a powerful visualization tool for efficiently communicating performance metrics against benchmarks and objectives. Their streamlined design facilitates rapid analysis and decision-making, making them ideal for management reporting and performance evaluation in various business contexts. By effectively displaying key data in a condensed format, Bullet Charts help organizations focus on critical results and strategic alignment.