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.

  • "Can anyone point me in the right direction?". As answered here aggregate is NOT a Google Sheets function. – marikamitsos Oct 2 '19 at 19:01
  • @marikamitsos This question is about a checkbox in chart settings not about a spreadsheet function – Rubén Oct 2 '19 at 19:14
  • 1
    @Rubén. Nice catch. I missed that. Thank you. – marikamitsos Oct 2 '19 at 19:30
  • Elliott: The question is too broad, please make it more specific. This could be done by choosing a chart type and adding sample input data. By the way Have already read Add & edit a chart or graph? – Rubén Oct 2 '19 at 21:14
  • That link doesn't mention the aggregate checkbox at all. I don't know what kind of dataset would be useful for this. With all the data I have tried, the setting does nothing. So I'm not really sure how I could clarify the question any further. – Elliott B Oct 2 '19 at 21:32

Your Answer

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

Browse other questions tagged or ask your own question.