Creating a Pie Chart from Pop-Up Menu Cell Type

Question

Level 1

9 points

Creating a Pie Chart from Pop-Up Menu Cell Type

I am making a time log to monitor the time I spend on tasks. My goal is to have an easy way to show the categories of time I spend on a daily basis.

I have created a simple table that calculates the hours I spend on a task. In the final column, I have pop-up menu type cells that allow me to chose a category to assign to that row.

How can I create a Categories Summary Table and subsequently a linked Pie Chart that will allow me to see each category's time?

I saw this thread: Re: Creating a pie chart based on Pop-up Menu in Numbers but it does not seem to work for me.

Here's what I have so far:

FYI, the formula I am using to deduce hours in column D is: IF(OR(ISBLANK(B2),ISBLANK(C2)),DURATION(0), C2−B2)

Any help would be MUCH appreciated. THANKS IN ADVANCE!!!!

Posted on Mar 26, 2016 4:39 PM

Reply

Answer 1

SGIII

Level 8

37,562 points

Mar 26, 2016 6:29 PM in response to Macasourous

The formula in your Summary table could look like this:

=SUMIF(Time Log::E,A2,Time Log::D)

To produce the chart, I selected all the cells in the Summary Table and chose 2D Pie.

SG

Reply

Answer 2

Barry

Level 9

60,023 points

Mar 26, 2016 10:20 PM in response to Macasourous

Hi M'

One addition to what SGIII said...

The category names on the Summary table must be an exact match for the corresponding category names on the Time Log table. The easiest way to make sure they are is to copy one of the pop-up menu cells in the Time log, then paste it into the cells in column A of the Summary.

Regards,

Barry

Reply

Answer 3

Macasourous Author

Level 1

9 points

Mar 27, 2016 6:33 AM in response to SGIII

THANK YOU, @SGIII and @Barry this works perfectly!

Reply

Answer 4

SGIII

Level 8

37,562 points

Mar 27, 2016 7:09 AM in response to Macasourous

When setting up Pop-Up Menu, note that you can select a range of cells containing the different values, format them as Pop-Up Menu and the menu items are generated automatically. You don't have to type them in manually. You can then copy-paste one of the cells elsewhere and the menu will be retained in the new location. Thanks for the green tick!

SG

Reply