Note: The other languages of the website are Google-translated. Back to English

Create a percentage ball chart in Excel

Normally, we are displaying progress with an advancing bar chart. However, In Excel, we can visually display percentage completion with other different charts, such as a progress circle chart (click to see how to make this chart). This tutorial demonstrates steps to create a ball chart that tracks the percentage completion of a project visually in Excel.

Create a percentage ball chart in Excel
Easily create a percentage ball chart with an amazing tool
Download the sample file
Video: Create band chart in Excel


Create a percentage ball chart in Excel

Supposing you are recording the percentage completion of a project in a cell as the below screenshot shown, you can do as follows step by step to create a percentage ball chart to visually display the percentage completion.

1. Select the cell containing the percentage completion, then click Insert > Insert Column or Bar Chart > Clustered Column.

2. Right click the chart and choose Select Data in the right-clicking menu.

3. In the Select Data Source dialog box, click the Add button.

4. In the popping up Edit Series dialog box, click OK directly without any configuration.

5. When it returns to the Select Date Source dialog box, select the new added series (Series2) and click the Move Up arrow to move this series to the top of the list box, and then click OK to save the changes.

Now the chart is displayed as follows.

6. Click Insert > Shapes > Oval. Then draw a circle in the worksheet with holding the Shift key.

7. Copy the inserted circle and paste to have the second one. Then format the second circle with another color: please select it, then click Format > Shape Fill, and then choose the fill color as you need.

Now there are two circles in your worksheet as the below screenshot shown.

8. Now you need to replace the columns in the chart with circles. Select one of the circles, press the Ctrl + C keys to copy it, go to the chart, select one of the columns, and then press the Ctrl + V keys to paste the circle. Repeat the operation to copy the other circle to the column that is left in the chart. See the below demo:

9. Right click on the series (the small circle) in the chart, and then select Format Data Series from the context menu.

10. In the Format Data Series pane, please configure as follows.

10.1) Change the Series Overlap to 100% under the Series Options tab;

10.2) Click the Fill & Line icon;
10.3) In the Fill section, select the Stack and Scale with option.

Now two ovals are overlapping in the chart as the below screenshot shown.

11. Adjust the chart by dragging the Chart Area until the shape turns to a circle ball.

12. Click Insert > Text Box, and then draw a text box on the ball.

13. Keep the text box selected, go to the Format (Drawing Tools) tab, and then select No Fill and No Line separately from the Shape Fill and Shape Outline drop-down lists.

14. Keep the text box selected, type an equal sign = into the Formula bar, click the cell containing the percentage completion value and then press the Enter key.

15. Now you need to format the text box as follows.

15.1) Enlarge its font size;
15.2) Adjust its position to make it showing on the center of the ball.

16. Remove the X-axis, Y-axis and the gridlines.

Then the percentage ball chart is complete as the below screenshot shown.

Notes:

1. The ball will be dynamically changed with the percentage completion value;

2. The textbox will not be moved with the chart.

Easily create a vertical or horizontal bullet chart in Excel

The Percentage Ball Chart utility of Kutools for Excel can help you quickly create a percentage ball chart in Excel with several clicks only as the below demo shown.
Download and try it now! 30-day free trail


Download the sample file


Video: Create percentage ball chart in Excel


The Best Office Productivity Tools

Kutools for Excel - Helps You To Stand Out From Crowd

Would you like to complete your daily work quickly and perfectly? Kutools for Excel brings 300 powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) and save 80% time for you.

  • Designed for 1500 work scenarios, helps you solve 80% Excel problems.
  • Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands.
  • Become an Excel expert in 3 minutes. No longer need to remember any painful formulas and VBA codes.
  • 30-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years.
Ribbon of Excel (with Kutools for Excel installed)

Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)

  • One second to switch between dozens of open documents!
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Firefox, And New Internet Explorer.
Screen Shot of Excel (with Office Tab installed)
Comments (1)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Добрый день.Все получилось, замечательно, только в диапазоне от 83,4 до 99,9 диаграмма работает криво и заполнение отражается некорректно. Не могу понять, что не так.И это работает в пределах 100%Какие варианты, если больше 100%, просто гистограмму применять?
There are no comments posted here yet
Leave your comments
Posting as Guest
×
Rate this post:
0  Characters
Suggested Locations