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.
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:
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.
Open Google Docs from docs.google.com and click on "Insert" > "Special characters" to find symbols that resemble Harvey Balls.
Choose symbols for different fill levels: ○ for 0%, ◔ for 25%, ◑ for 50%, ◕ for 75%, and ● for 100%.
Copy the symbol you need.
Then, paste it into the selected cells in Google Sheets.
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.
