TransWikia.com

How to make time series chart, where all rows are labelled and dates are not unique?

Web Applications Asked by Connor Owen Mcshane on December 23, 2020

Say I have some data like so

| Month | Count | Type |    |    |
|-------|-------|------|--- |--- |
|     1 |     2 | A    |    |    |
|     1 |     3 | B    |    |    |
|     2 |     1 | A    |    |    |
|     2 |     2 | B    |    |    |
|     3 |     1 | A    |    |    |
|     3 |     1 | B    |    |    |​

I would like to create a line chart, which each Type would have its own line.

In data studio this behaviour is set by default, but is there an easy way to do it with google sheets?

Thanks

One Answer

See Test sheet

Idea is to make pivot table to group your data by type and month and create chart based on pivot table. Since data may be updated, increase range of pivot table and filter blanks.

Answered by Oleg_S on December 23, 2020

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP