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
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
0 Asked on January 24, 2021 by rietty
0 Asked on January 23, 2021 by user261687
1 Asked on January 23, 2021 by y-lin
formulas google sheets google sheets arrayformula google sheets query vlookup
1 Asked on January 18, 2021 by wil
1 Asked on January 17, 2021 by joel-zorrilla
2 Asked on January 17, 2021
0 Asked on January 16, 2021 by roser-veronica
1 Asked on January 15, 2021 by ananth
gmail google hangouts google hangouts chat google workspace privacy
3 Asked on January 13, 2021 by genny
1 Asked on January 10, 2021 by diane
0 Asked on January 7, 2021 by zhro
0 Asked on January 6, 2021
1 Asked on January 3, 2021 by richard-novy
Get help from others!
Recent Questions
Recent Answers
© 2022 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP