Year-over-year sales chart by month

ncroweatstance Member

January 2023 in Charting

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

0

Best Answer

• 

  DashboardDude Coach

  January 2023 Answer ✓

  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

  

  John Le

  You're only one dashboard away.

  Click here for more video solutions: https://www.dashboarddudes.com/pantry

  1

Answers

• 

  GrantSmith Coach

  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.

  **Was this post helpful? Click Agree or Like below**
  **Did this solve your problem? Accept it as a solution!**

  2
• 

  DashboardDude Coach

  January 2023 Answer ✓

  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

  

  John Le

  You're only one dashboard away.

  Click here for more video solutions: https://www.dashboarddudes.com/pantry

  1
• 

  ncroweatstance Member

  January 2023

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

  1