How to Create Half Circle KPI Chart in Excel?

  1. Take sample data. Select data for Project-1 as indicated below.

 

 

Half circle KPI chart

 

 

2. Go to the ribbon, select Insert, and select your chart type from the chart group.

 

 

Half circle KPI chart

 

 

3. Select Chart type as Doughnut.

 

 

Half circle KPI chart

 

 

4. The chart looks below.

 

 

Half circle KPI chart

 

 

5. For changing the angle and the doughnut hole size, Right click on the chart and select Format Data Series.

 

 

Half circle KPI chart

 

 

6. Change the angle size and the doughnut hole size from the Series Option.

 

 

Half circle KPI chart

 

 

7. To remove the outline from the chart, select Format in the ribbon, click Shape Outline, and Choose No Outline.

 

 

Half circle KPI chart

 

 

8. To Remove the legend at the bottom, select the legend and delete it.

 

 

 

Half circle KPI chart

 

 

9. To make the full circle into a half-circle, Right click on the bottom part of the chart and select Format Data Series.

 

 

Half circle KPI chart

 

 

10. Then go to the Series Option, and click No Fill.

 

 

Half circle KPI chart

 

 

11. In the following steps we will customize the arc of the pie/circle as below:

 

 

Half circle KPI chart

 

12. For changing the Theme style of the pie/arc of the circle – select the pie and – go to Format in the ribbon. Click the drop-down arrow in the Shape Styles Group.

 

 

Half circle KPI chart

 

 

13. Choose the theme color of the First part of the chart.

 

 

Half circle KPI chart

 

 

14. To change color in the second part of the chart, select Format in the ribbon, click Shape Fill and choose a color.

 

 

Half circle KPI chart

 

 

15. To change color transparency in the second part of the chart, right-click on the chart to go to Format Data Series Select Series Option, and change the transparency level.

 

 

Half circle KPI chart

 

 

16. To show Data Label in the middle of the circle, we need to insert a rectangular share. Select Insert in ribbon, click Shape from Illustrations, and Choose a shape.

 

 

Half circle KPI chart

 

 

17. Select the shape and link the data cell in the formula bar. Format the shape as no outline and drag it to the center of the chart.

 

 

Half circle KPI chart

 

 

18. The chart looks below.

 

 

Half circle KPI chart

Leave a Comment

Your email address will not be published. Required fields are marked *

Categories