4 Replies Latest reply on Nov 9, 2016 1:06 PM by Pavani Donepudi

    Line chart with a 6-6 month comparison

    Aditi N

      Hi,

       

      I have a simple line chart with a monthly trend of Cost for 'latest' 12 months. I am trying to change this chart to depict a 6 monthly change in cost. So, I would like to show a trend of cost latest 6 months over previous 6 months. I have attached a sample workbook. In trial sheet, I tried to compare but I can only compare by Year to Year which is not what I need.

       

      It seemed like a very simple thing to do, but I am unable to find any option to do this!

       

      I would greatly appreciate any help! Thank you.