Skip to main content

Create a percentage ball chart in Excel

Author: Siluvia Last Modified: 2021-02-09

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

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions
Popular Features: Find, Highlight or Identify Duplicates  |  Delete Blank Rows  |  Combine Columns or Cells without Losing Data  |  Round without Formula ...
Super VLookup: Multiple Criteria  |  Multiple Value  |  Across Multi-Sheets  |  Fuzzy Lookup...
Adv. Drop-down List: Easy Drop Down List  |  Dependent Drop Down List  |  Multi-select Drop Down List...
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  Compare Columns to Select Same & Different Cells ...
Featured Features: Grid Focus  |  Design View  |  Big Formula Bar  |  Workbook & Sheet Manager | Resource Library (Auto Text)  |  Date Picker  |  Combine Worksheets  |  Encrypt/Decrypt Cells  |  Send Emails by List  |  Super Filter  |  Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters ...)  |  50+ Chart Types (Gantt Chart ...)  |  40+ Practical Formulas (Calculate age based on birthday ...)  |  19 Insertion Tools (Insert QR Code, Insert Picture from Path ...)  |  12 Conversion Tools (Numbers to Words, Currency Conversion ...)  |  7 Merge & Split Tools (Advanced Combine Rows, Split Excel Cells ...)  |  ... and more

Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need is Just A Click Away...

Description


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, Edge and Firefox.

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