How to☝️ Use Harvey Balls in Excel

To insert a Harvey Ball into your Excel spreadsheet, select the cell where you want the symbol, type =UNICHAR() into the Formula bar with the specific code you need, and press the Enter key. The codes are provided below.

There are multiple ways to add Harvey Balls to your spreadsheet. Read on below to learn the various ways and decide which one is best for you!

Method 1: Using the =UNICHAR() Function

Difficulty: Beginner
Time Estimate: 10 Seconds

1. Click on the cell where you want to add the symbol.

2. Go to the Formula bar and enter the formula =UNICHAR() with the code you need added between the parentheses.

Using the =UNICHAR() Function

3. Press Enter on the keyboard.

Here is the list with Unicode (hex) numbers for the different types of Harvey Balls:

Unicode (hex) numbers for the different types of Harvey Balls

Just type the appropriate code in the formula and get the desired result!

Method 2: Copying the Symbol from Another Source

Difficulty: Beginner
Time Estimate: 10 Seconds

1. Browse any site that provides symbols and highlight the Harvey Ball you want.

Copying the Harvey Ball

2. Press the Ctrl+C/Cmd+C key combination to copy the symbol.

3. Go to your Excel spreadsheet and click on the cell where you want the symbol.

4. Press the Ctrl+V/Cmd+V key combination to paste the symbol.

Just like that, you have your result! Let’s move on to the next method.

Harvey Ball

Method 3: Using the Insert Tab

Difficulty: Beginner
Time Estimate: 15 Seconds

1. Select the cell where you need to add the symbol.

2. Navigate to the Insert tab.

3. Go to the Symbol category.

4. Choose the Segoe UI Symbol font.

5. Pick the Geometric Shapes subset.

6. Choose the symbol you want.

7. Click the Insert button.

Using the Insert Tab

So simple! You have successfully added the Harvey Ball symbol.

The Harvey Ball

Method 4: Using Conditional Formatting

Difficulty: Beginner
Time Estimate: 25 Seconds

1. Select the cell where you want the symbol.

2. Go to the Home menu.

3. Click on the Conditional Formatting option.

4. Pick Icon Sets.

5. Choose the icon set you need.

Using Conditional Formatting

6. Navigate back to the Home tab.

7. Go to the Conditional Formatting option again.

8. Click on Manage Rules.

Conditional Formatting option

9. Double-click on the Icon Set rule.

Icon Set

10. Check the Show Icon Only option.

11. Set the rules you would like to display the symbol.

12. Click OK.

Show Icon Only option

That’s all there is to it! 

Harvey Balls FAQs

Take a look at some questions and answers below to dive into this topic and learn more!

What are Harvey Balls? 

Harvey Balls are circular symbols that are used to indicate the degree of completion of a task. The Harvey Ball is named after Harvey L. Poppel, who developed the concept in the early 1970s. 

What are the Harvey Ball types?

There are five different levels of completion that can be indicated by Harvey Balls: Incomplete, Partially Complete, Half Complete, Mostly Complete, and Complete.

In which situations are Harvey Balls used?

Harvey Balls are frequently employed to represent the progress or state of something. Harvey Balls can illustrate the advancement of a project, risk levels, or the severity of a weather episode, for example.

More Google Sheets Tutorials
More Microsoft Excel Tutorials
Share This Post
Daniel Smith
Daniel Smith
Daniel Smith is automation consultant with a passion for technology, data, AI, and machine learning.

The Spreadsheet Daddy add-on rebrands to Synterrix. Click here to learn more.

X