Google Sheets Pie Graph Aggregation Merges Completely Different Categories

Question

I've been trying to make a basic chart in google sheets that puts together the time taken for various activities to make a pie chart. Since the same activities appear multiple times I need to aggregate the data. However, it doesn't work in the way I would hope as it puts both the productive and unproductive categories under unproductive. I don't believe this is supposed to happen but I haven't seen anybody else have the same problem. It also should be noted that the unaggregated chart IS accurate to the data I fed in. It's only when I attempt aggregation and things don't work.

Graph without aggregation:

Graph with aggregation:

Answer 1

You want to create a doughnut chart from some data. In the first instance you do not aggregate the data. But when you do aggregate the data, the outcome is not as you expect - "Productive" data is included with "Unproductive" data.

I believe that you have a flaw in the way that you are designing your data and defining the Data Range for the Charts.

---

In both of the following example, the data range for each charts is "A1:B10".

As you can see, Productive time is included (and aggregated).

Data and Charts