Charts for Reports (costs and hours worked)

I am working on a report, where a company has different projects and they can input every day the amount of hours each worker has worked on the project. Each worker has a value of costs per hour, so the total costs per day are automatically calculated.

I would like to show a chart where the total amount of hours worked (and costs) are shown per project. I can’t get it set up correctly. The charts feature seems to pull in the values of the whole sheet, even if you place it on a single item screen - and dynamically filtering based on the project, which is opened by the user, doesn’t seem to work either.

It’s late here, so maybe I just hit a mind block or is there really no workaround for this?

I believe you can point a chart to a relation, so if you have your relation set up correctly, it will be filtered data.