Year-over-year sales chart by month

ncroweatstance · January 2023

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 · January 2023

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 · January 2023

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 · January 2023

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 · January 2023

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

Year-over-year sales chart by month

Best Answer

Answers

Categories