5 Replies Latest reply on Aug 29, 2018 2:51 PM by Nitin Paighowal

    Making an 18 month Year over year comparison

    Eugene Trilesnik

      Hey guys, I have a data set.

       

      Set 1: January 2016 - june 2017

      Set 2: January 2017 - June 2018

      Set 3: January 2018 - June 2019

       

       

      When I try to do a month analysis aka show all 3 lines on 1 graph, colored by year, january-december it doubles up on the months that have double data. Set 1 January 2017 and set 2 January 2017. The way I countered this was just to display 12 months of data but im being asked to figure out how to do a full 18 month comparison. I was wondering if I could extend it so it goes january  - december - june all on one axis.

       

      Please let me know if something can be done! Thank you. I have attached a test data workbook.