Year-over-year sales chart by month

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

Best Answer


  • GrantSmith
    GrantSmith Indiana 🥷

    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!**
  • This helped resolve my question. Thank you for the video @DashboardDude! Also, I want to thank @GrantSmith, appreciate you as well!