To chart pop-up menu choices in Numbers on Mac, create a summary table that counts each choice with COUNTIF, then build a pie chart from those numeric counts. This walkthrough uses a small set of geometric shapes and explains how to handle blanks and later changes.

The instructions follow Apple’s current Numbers User Guide for Mac, which identifies Numbers 15.4. The task is to show how often each selected shape occurs, with one wedge per shape.

Set up the choices you want to count

Use two tables on the same sheet: one named Objects for individual objects and their selected shapes, and another named Summary for the counts. Keeping the input and summary separate makes it easier to inspect the chart’s underlying numbers. Add a table using the toolbar’s Table button; double-click its table title to rename it. Apple documents these operations in Add or delete a table and Show, hide, or edit a table title.

In Objects, use column A for object names and column B for shapes. Put the headings in row 1 and the ten sample objects in rows 2–11. The empty entries below mean genuinely empty cells; do not type the word “blank.”

Row Column A: Object Column B: Shape
1 Object Shape
2 Object A Circle
3 Object B Square
4 Object C Circle
5 Object D Triangle
6 Object E Square
7 Object F Circle
8 Object G
9 Object H Square
10 Object I Circle
11 Object J

To turn the shape cells into menus, select B2:B11. In the Format sidebar, click Cell, open Data Format, and choose Pop-Up Menu. Numbers builds menu options from existing selected values, consolidates repeated values into single options, and preserves each cell’s original selection. Check that the options are Circle, Square, and Triangle. For cells awaiting a choice, choose Start with Blank below the options. These controls are described in Apple’s Add controls to cells.

If you begin with empty cells instead, replace the placeholder menu items with those three shape names. Use the add-item button below the list when another option is needed. Apple permits up to 250 menu items, although this example needs only three. Choosing Start with First Item supplies a default selection; use Start with Blank when an unchosen object should remain unclassified. Apple’s pop-up menu instructions explain both starting options.

Count each selected choice with a summary table

Create Summary with two columns and four rows. Use one header row, and make the first column a header column so the shape names can serve as chart labels. Enter the following headings and labels; leave the count cells empty until you add the formulas.

Cell in column A Text Corresponding count cell
A1 Shape B1: Count
A2 Circle B2
A3 Square B3
A4 Triangle B4

Apple defines COUNTIF(test-array, condition) as counting cells in a collection that satisfy a condition. Its input collection can contain text, and the condition can be a cell reference. That lets each summary label supply the choice to count. See Apple’s COUNTIF function reference.

Enter these formulas in the specified cells of Summary:

Cell Formula Expected result
B2 =COUNTIF(Objects::$B$2:$B$11,A2) 4
B3 =COUNTIF(Objects::$B$2:$B$11,A3) 3
B4 =COUNTIF(Objects::$B$2:$B$11,A4) 1

Click a destination cell and type = to open the formula editor, enter the formula, then press Return. If Numbers displays an error icon, click it to read the message before continuing. Apple’s Calculate values using data in table cells documents formula entry and error inspection.

The reference Objects::$B$2:$B$11 identifies the source table and its ten shape cells. The double colon separates the table name from the range. Dollar signs keep the source range fixed when the formula is copied, while A2, A3, and A4 identify the corresponding summary labels. Apple explains table references and absolute references in Refer to cells in formulas.

If your settings use a comma as the decimal separator, separate formula arguments with a semicolon. For example, the first formula becomes =COUNTIF(Objects::$B$2:$B$11;A2). This locale-dependent syntax is documented in Apple’s Functions overview.

The test-array argument here is the input range being examined. Each shown formula produces one count in its own cell. This method needs no array-output formula: enter one formula for each summary label, following the documented single-condition use of COUNTIF.

Create the pie chart from the counts

Select A1:B4 in Summary, click the toolbar’s Chart button, choose 2D, and select a pie chart. This uses the summary labels and numeric results as the chart source. Apple supports selecting the table data before creating the chart and automatically updates the chart when its source values change. See Select data to make a chart and Add column, bar, line, area, pie, donut, and radar charts.

The intended result is one numeric series containing three counts: 4, 3, and 1. If the chart’s arrangement is wrong, select it, click Edit Data References, and choose Plot Columns as Series from the pop-up menu at the bottom of the window. Confirm that the selected range belongs to Summary, then click Done. Apple documents the orientation controls in Modify chart data.

Do not include an overall total as another category. In this example, adding a fourth value of 8 would make the displayed total 16 and give the total itself half the pie. Keep any checking total outside the selected chart range.

To label the wedges, select the chart and open Wedges in the Format sidebar. Enable Values, then use the Value Data Format controls to choose a number or percentage display. Enable Data Point Names to show the shape names. To add a descriptive title, open the Chart tab, enable Title, and replace the placeholder with Selected Shapes. Apple documents these settings in Change the look of chart text and labels.

For the illustrative data, the selected shapes total eight: four circles, three squares, and one triangle. Their shares are therefore 50%, 37.5%, and 12.5%. The two empty cells are outside that denominator because none of the three shape conditions matches them. A title such as Selected Shapes makes that scope clear.

Check blanks, updates, and missing categories

Before relying on the chart, perform a small change test. Change Objects::B2 from Circle to Square. The expected counts become 3, 4, and 1; the total remains eight. Restore the original choice afterward. This tests both the counting references and the chart’s connection to the summary.

Decide what an unchosen object should mean. For a chart of completed selections, keep blanks outside the pie. For a chart covering every object, add an explicit menu option such as Unassigned, select it for the relevant objects, and add a matching summary row and count formula. In this sample, including two unassigned objects would produce shares of 40%, 30%, 10%, and 20%. These percentages are illustrative calculations from the sample’s ten objects.

Use this sequence when a result looks wrong:

  1. Inspect the source value. Check that the summary label and menu choice use the same wording. For labels containing a literal * or ?, remember that COUNTIF treats those characters as wildcards; Apple documents escaping them with ~ in its COUNTIF reference.
  2. Inspect the source range. The example formulas cover only rows 2–11. When objects are added outside that range, update all three formulas. For a dedicated shape column, a whole-column reference such as =COUNTIF(Objects::B,A2) is another supported reference form. Apple’s cell-reference guide documents whole-column notation.
  3. Inspect the summary categories. Adding a menu option does not add a row to this manually constructed summary. Add the corresponding label and formula, then extend the chart’s data reference.
  4. Inspect chart visibility. Hidden or filtered chart-source data is excluded by default. Apple provides a Hidden Data checkbox under Format, Chart, and Chart Options when that data should be included. See Modify chart data.

Conditional highlighting can help you inspect cells, but keep the counting rules based on their values. Apple documents highlighting as changing a cell’s appearance when its value meets a rule; a rule may compare that value with another cell. It does not document those rules as chart-wedge styling controls. Configure chart labels separately, and use the summary’s numeric results as the chart source. See Use cell conditions in Numbers on Mac.

Keep the summary visible while checking your finished chart. With this sample, the original selections should produce counts of 4, 3, and 1, totaling eight chosen objects. Once the counts, denominator, and chart range agree, changing a menu choice gives you an understandable path from the input cell to its count and wedge.

Sources