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

This article mainly introduces the relevant knowledge of "Excel how to make Bullet diagram". The editor shows you the operation process through an actual case. The operation method is simple and fast, and it is practical. I hope this article "how to make Bullet diagram in Excel" can help you solve the problem.

Bullet diagram

Bullet diagram was invented by Stephen Few. Bullet diagram is used to replace the speedometer to reflect the completion of KPI, especially multiple KPI indicators, without taking up a lot of space. The way to read the Bullet diagram is that the black bar represents the reality, the small vertical bar represents the target, and the gray of different shades indicates different satisfaction intervals.

In this section, with the help of EXCEL software, make a beautiful and intuitive Bullet diagram, Bullet diagram usually represents the achievement of KPI, the practice is relatively simple, the graphic effect is shown below.

Operation steps

Step 1, select the data. We choose the income target value and the actual income value of each district across the country, in units per million, and the data is fictional, which can be changed according to the actual situation to set the three income ranges of general, good and excellent, because we need to do stacked bar charts. if it is generally 60, good is 75, excellent is more than 90, then when setting data, it is generally 60, good is 15, excellent is 15.

Step 2, stack the bar chart. Select all the data, insert the stacked bar chart, and choose the second chart style, which uses each partition as the horizontal axis and the actual data value as the ordinate.

Step 3, change the chart type. Click on the chart, right-click to change the chart type, change the target to a line chart, secondary coordinates, actually change to a cluster column chart, secondary coordinates, the rest are stacked column charts, the chart type remains the same.

The first version of the effect is as follows: step 4, data series formatting. Click the actual column, select the secondary axis, and adjust the gap width to 300. The higher the value, the narrower the column.

Step 5, data series format setting. Click the "Target" break line, select "Wireless Bar" in "Line", and then in "tag", select "built-in", set the line to be marked as a short horizontal line, fill in red, and select "none" in the border.

Step 6, theme color filling. Then fill the general, good and excellent columns with different saturation colors of the same color system, and remove the grid lines, delete the secondary coordinate axis, and add the chart title to make the Bullet diagram.

This is the end of the introduction to "how Excel makes Bullet diagrams". Thank you for your reading. If you want to know more about the industry, you can follow the industry information channel. The editor will update different knowledge points for you every day.

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.