MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How Do I Create Charts From Pop-up Categories?

Hey guys,

I have a numbers table in which I note down the time I spend on different project stages (these stages, such as «concept phase», «transfer», «book keeping» and so on are integrated via popup-menu).

Now I would like to create a single chart in which all hours spent on different project stages from the popup-menu are shown in relation to each other (sorted by stage with the total of spent hours representing 100%).

Probably a basic task – I’m new to numbers.

I would like to visualize the amount of time I spend on certain tasks during bigger projects. It’s also possible that there is a time limit that shouldn’t be exceeded and a chart helps to keep track of the available hours.
—–
basil

Comments: 2 Responses to “How Do I Create Charts From Pop-up Categories?”

    5 months ago

    Before you create a chart, create the table for the chart. So make a new table and put each category in column A. Then in column B, use SUMIF functions to get the total from the other table.

    See https://macmost.com/using-the-numbers-sumif-function.html to learn about SUMIF.

    basil
    5 months ago

    Thank you very much Gary!

Leave a New Comment Related to "How Do I Create Charts From Pop-up Categories?"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)