How to make charts work like Google Sheets? What am I missing?

Numbers can/will do this, but there's an extra step involved.

Google Sheets is silently aggregating the data, which is handy in some cases.

In Numbers, though, you have to provide that hint first. Fortunately it's easy to do using Categories.

In Inspector -> Organise -> Categories, tell Numbers you want to categorize your data based on the New/Used column:

This will split your table into groups based on the values in the specified column.

Then you need to tell Numbers how you want to summarize the data - in this case, you want the Count() of each group, so click the header cell in the first group and click the gear wheel icon to display the Summary options:

Select Count (All) to get a count of all the values in this group.

Now your table should look like this:

Now Numbers has the details it needs to do what you want. Select the New/Used column and click the Chart -> Pie Chart option in the toolbar and it will build a pie chart based on the categories, rather than the individual row data:

Once setup, you can toggle the Categories on and off in the Inspector -> Organize.

Hi David,

The COUNTIF function is your friend.

Formula in Footer cell B19 is COUNTIF(B,"=New")

Formula in Footer cell B20 is COUNTIF(B,"=Used")

Select B19 and B20 and insert a Pie Chart.

Regards,

Ian.

Another easy way involving just a few clicks and drags (and leaves your original data untouched) is via Pivot Table.

Click in the table with your data, in the menu choose Organize > Create Pivot Table > On Current Sheet. In the Pivot Options pane that appears on the right drag the New/Used field into the Rows and Values boxes, then click anywhere in the Pivot Table and choose Insert > Chart > 2D Pie.

It's not one-click. But it's very fast and efficient and gives nice-looking results in seconds.

SG

David MacVicar wrote:

...why can Google Sheets easily calculate this, but I need to perform extra steps in Numbers to do the same thing?

Because they are different apps written by different people working for different companies. You can say the same thing about Excel. All have unique features not available in the others. They are not clones of each other.