In this article:

Harvey Balls in Google Sheets (Easiest Way to Use It in 2024)

May 8, 2024

Harvey Balls in Google Sheets

Harvey Balls are a form of visual communication tool used to represent qualitative information or the degree of completion, satisfaction, or performance in a compact, visual format. They are essentially circular symbols that are filled in to varying degrees to indicate a level or score. 

In the context of Google Sheets, Harvey Balls can be used to visually represent data such as project progress, customer satisfaction ratings, or product comparisons directly within your spreadsheets.

How to Use Harvey Balls in Google Sheets

Google Sheets doesn't have a built-in feature specifically called "Harvey Balls, but you can create them using Google Docs. Follow the steps below:

1. Highlight Cells for Harvey Ball Insertion

Click and drag to select the cells where you want to insert Harvey Balls. These cells will visually represent data like completion levels or performance ratings.

harvey balls in google sheets

2. Copy Special Characters from Google Docs and Paste into Sheets

Open Google Docs from docs.google.com and click on "Insert" > "Special characters" to find symbols that resemble Harvey Balls.

google sheets harvey balls

Choose symbols for different fill levels: ○ for 0%, ◔ for 25%, ◑ for 50%, ◕ for 75%, and ● for 100%.

harvey balls google sheets

Copy the symbol you need.

Then, paste it into the selected cells in Google Sheets.

3. Apply Conditional Formatting for Automated Visual Representation (Optional)

For automation, use conditional formatting. Select your cells, click "Format" > "Conditional formatting".

Set rules to change the cell's background color based on its value.

This visually represents data without actual Harvey Balls.

We hope that you now have a better understanding of how to use Harvey Balls in Google Sheets. If you enjoyed this article, you might also like our article on how to set up getDataRange in Google Sheets or our article on how to make a correlation matrix in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->