0

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

0

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.

| improve this answer | |
  • Amazing!!! I am new to google sheets so was unaware of pivot tables – Connor Owen Mcshane Aug 4 at 9:47

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.