5

Line graphs and most other types in Google Sheets have a checkbox for "aggregate" in the setup tab. I've tried looking through the instructions but I can't find any documentation on how to use this feature. Can anyone point me in the right direction? An example data set where it's useful would be really helpful.
I've tried enabling it on various charts with different data, but it never changes anything.

2

With some playing around, I figured out what the aggregate feature does.

Basically, the aggregate feature allows you to aggregate all values that share an identical x-axis key.

Normally, if you have duplicate x-axis keys, your chart will look something like this, with values having the same key forming vertical lines:

enter image description here

(I've increased the width of the lines to make it easier to see what's happening.)

But perhaps this isn't the behavior you want. Perhaps, instead, you want all y-values with the same x-value to be summed, and only the summation to be plotted. The aggregate feature lets you do this.

First, turn on the aggregate feature, and select the desired aggregation method:

enter image description here

After making these edits, instead of y-values with identical x-values resulting in vertical bars, the aggregation of the y-values for a given x-values will be graphed:

enter image description here

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.