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

This article introduces how to make KPI battery diagram with EXCEL tool. The content is very detailed. Interested friends can refer to it for reference. I hope it can help everyone.

KPI is often used to measure the performance indicators of department personnel. From KPI battery chart, we can clearly see the KPI achievement of sales individuals. For achieving good sales continuous incentive and achieving backward sales, is it time to "charge", empower sales training and tap potential business opportunities.

Below, with the help of EXCEL tool, use the case data to make KPI battery diagram, and the data effect is shown below. For the complete drawing process, see the following article.

The first step is to construct an auxiliary column. The original data table used in this article is shown below. The data situation is fictitious. First, construct an auxiliary column. The auxiliary column is equal to the actual completion value divided by the KPI indicator value.

Step 2: Select the name, KPI indicator and actual completion value, insert the clustered column chart, double-click the chart, open the format adjustment box on the right, enter 100% in the series overlap, and adjust the classification spacing value to 150. Step 3, click the Insert tab, insert two rounded rectangles, splice them into a battery shape, and then copy them, click the column in the chart, paste them, and the battery will replace the original column, as shown in the following figure: Step 4, click the orange column, select the pattern fill in the fill in the data series format, select the horizontal pattern, and get the following figure. Step 5: Add a data label to represent the KPI value in the form of a numerical value and the achievement rate in the form of a percentage. Click the blank area of the battery chart and click the "+" to check the data label to obtain the KPI value. Step 6: Click the pattern part again, click the " +" mark to check the data label to get the actual completed value, click the latter, right click> select data> box check auxiliary column to get the achievement rate, cancel the value in the label, and center the label position. Step 7. Beautify the chart by removing the grid lines and headings, placing the legend at the top, and adding text descriptions to tell the story with the data.

About how to use EXCEL tools for KPI battery map production to share here, I hope the above content can be of some help to everyone, you can learn more knowledge. If you think the article is good, you can share it so that more people can see it.

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.