AnswerBun.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!

Related Questions

Google Sheets: Lookup Value that falls after a Timestamp

0  Asked on January 23, 2021 by user261687

 

Twitter trending list not correct

1  Asked on January 23, 2021 by beth202

   

Can I send support questions to Google via email?

1  Asked on January 17, 2021 by mafu

 

Email forwarding to Gmail and SPF

1  Asked on January 13, 2021 by daunpunk

   

Why is my Twitter Page in Arabic?

1  Asked on January 10, 2021 by mariana-beaumont

 

How to sort files in folder by date created?

3  Asked on January 8, 2021 by user1306322

 

Why I am getting this error message from Gmail?

0  Asked on January 4, 2021 by abu-bakar-saadat

 

Ask a Question

Get help from others!

© 2022 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP