Sum in report in chart
I need to make a chart of two results.
Collecting data from multiple sheets via a report. I include all the sheets needed, and then make groups for the two different items.
As shown in the picture below, "Timer brukt" sums up to 602,5 and "Timer kalkulert" sums up to 1104,7.
How can I get these two together in one chart?
I understand that these sums only add upp in the report and cannot be extracted. But it must be possible to gather this info in a sheet or something?
I like to use report, because the list of sheets will increase an I need the sum to count new items in. That way I think it is inconvenient to link cells, since I then have to add new links in the summary sheet.