2 Replies Latest reply on Mar 7, 2016 1:18 PM by Oxana Jomiru

    How to display a line chart by aggregating dates?

    Oxana Jomiru

      I am able to display the timeline semester by semester. However I would like to display it by the harvest year (three semesters at a time combined/aggregated). How would I do that? Enclosed is my workbook showing the timeline with the semesters.

       

      So, what I would like to see is a "point" on the line chart for each Harvest year (with the sum of weight for three semesters), rather than a point for each semester that is a part of the harvest year.

       

      Thank you in advance!