Pie Chart Using Boolean Values in Google Sheets [How To]

To create a simple pie chart using Boolean values in Google Sheets, you can use the COUNTIF function. This method is straightforward, making it perfect for beginner-level Sheets users.

Let’s say you want to compare the monthly performance of two employees based on their daily targets and achievements. Since a pie chart is ideal for visualizing proportions and is easy to interpret, it fits well for this scenario.

In my sample data, there are three columns: the first column contains date entries, and the other two columns are filled with TRUE/FALSE checkboxes—one for each employee.

Here’s the sample dataset. For simplicity, I’ve used 15 days’ worth of data to reduce the number of rows in the screenshot.

Sample Data to Plot a Pie Chart Using Boolean Values

I inserted the checkboxes using the Insert > Tick box command. A ticked (checked) box has the value TRUE (which is treated as 1), and an unticked box has the value FALSE (or 0).

Must Read: 10 Best Tick Box Tips and Tricks in Google Sheets

Now let’s see how to create a pie chart using the count of Boolean values in Google Sheets.

How to Create a Pie Chart Using Boolean Values (TRUE/FALSE) in Google Sheets

Pie chart using tick box (TRUE/FALSE) values in Google Sheets

Here are the COUNTIF formulas you’ll need:

Step 1: Count the TRUE values

To count the total number of ticked boxes for Employee 1 (range B2:B16), enter the following formula in cell D1:

={B1; COUNTIF(B2:B16, TRUE)}

Additional Tip

You can also use the SUM function as an alternative:

={B1; ARRAYFORMULA(SUM(N(B2:B16)))}

In this formula:

The N function converts TRUE to 1.
ARRAYFORMULA is required because N is a non-array function.
The result is the count of TRUE values in the range.

This is just for your information—you can stick with the COUNTIF method.

Next, in cell E1, use this formula to count TRUE values for Employee 2 (range C2:C16):

={C1; COUNTIF(C2:C16, TRUE)}

Step 2: Create the Pie Chart Using Boolean Values in Google Sheets

Now that you have the counts of TRUE values for both employees:

Select cells D1:E2, which contain the count results.
Go to Insert > Chart.
Change the chart type to Pie chart.
Under Chart setup, enable Switch rows/columns.

You should now see a pie chart comparing the performance of both employees based on the number of days they met their targets.

Example 2: Pie Chart Showing Attendance (Present vs Absent)

Let’s say you’re tracking the attendance of an employee over 15 working days using a single checkbox column. A ticked box (TRUE) means Present, and an unticked box (FALSE) means Absent.

In this case, we want to show both the present and absent counts in a pie chart.

Pie chart using Boolean values (Present/Absent status checkboxes) in Google Sheets

Step 1: Use this formula to count both TRUE and FALSE values:

={"Status", "Count";
 "Present", COUNTIF(B2:B16, TRUE);
 "Absent", COUNTIF(B2:B16, FALSE)}

This will output a small summary table with the count of Present and Absent days.

Step 2: Insert the Pie Chart

Select the formula output (e.g., D1:E3).
Go to Insert > Chart.
Choose Pie chart under the Chart type.
Done! You now have a pie chart showing attendance status.

This is another good example of creating a pie chart using Boolean values in Google Sheets.

Wrap Up

We’ve now covered two useful examples of creating a pie chart using Boolean values in Google Sheets:

Comparing the performance of two employees (counting only TRUE values).
Showing attendance status using both TRUE and FALSE.

To summarize: when working with TRUE/FALSE or tick box fields, use COUNTIF (or SUM) to get the numerical values first, and then use that output to build your pie chart.