Year-over-year sales chart by month

ncroweatstance

Can someone recommend how to create a chart like in this image? The table in the image is just to show how I do it in excel

Thanks in advance

DashboardDude

Hi @ncroweatstance ,

So first of all @grahamwalkeradv is completely correct. I just wanted to make a video to make it easier for you to follow: https://www.loom.com/share/62bc7d1e47f24ac1a46b8df9464ee16d

Hope that helps!

John Le

You're only one dashboard away. 

More video solutions at: https://www.dashboarddudes.com/pantry

GrantSmith

Try pivoting your data so that you have a year column, month column and a value column. Then you can use the Month as your x-axis and the year as your series with the value as your y axis.

DashboardDude

Hi @ncroweatstance ,

So first of all @grahamwalkeradv is completely correct. I just wanted to make a video to make it easier for you to follow: https://www.loom.com/share/62bc7d1e47f24ac1a46b8df9464ee16d

Hope that helps!

John Le

You're only one dashboard away. 

More video solutions at: https://www.dashboarddudes.com/pantry

ncroweatstance

This helped resolve my question. Thank you for the video @DashboardDude! Also, I want to thank @GrantSmith, appreciate you as well!