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
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.
Thank you very much Gary!