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

  Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more

  Signup here:

  https://www.dashboarddudes.com/newsletter

  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

  Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more

  Signup here:

  https://www.dashboarddudes.com/newsletter

  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