How to create a line chart in a dashboard?

Lashawnta Barker

Please read carefully!

I want to create a line chart in my dashboard. I have 2 years worth of counts broken out by quarters.

I want each year to be it's own line in a line chart. Any idea how I can create this? Currently, it's all 1 line.

Thank you in advance.

SB

Heather Duff

Hello,

I think I may have found a solution, but it will require a tiny bit of rearranging your data sheet:

If you separate the columns by year, then it recognizes that Q1 in 2020 should be compared to Q1 in 2021. Here's the line chart I got from that:

Hope this helps!

Best,

Heather

Lashawnta Barker

Thank you Heather.

That worked wonderfully.

SB

Heather Duff

Hello,

I think I may have found a solution, but it will require a tiny bit of rearranging your data sheet:

If you separate the columns by year, then it recognizes that Q1 in 2020 should be compared to Q1 in 2021. Here's the line chart I got from that:

Hope this helps!

Best,

Heather

Lashawnta Barker

Thank you Heather.

That worked wonderfully.

SB