11 Replies Latest reply on Feb 3, 2017 6:01 AM by Cathy Schatzke

    How to create a continuous line when using a row with calculated field

    Cathy Schatzke

      I have a worksheet with a calculated field for the rows (HH:MM:SS) and a Week Number for the columns.  I have produced a line connecting my dots, but that line doesn't connect from Week to Week, it connects from high to low HH:MM:SS.  For example, Week 3 and Week 9 have the same values, and so the line goes from Week 3 to Week 9 and then back to Week 4.  Can someone tell me how I can connect the dots in order by week number?   Thanks!

       

      I am adding another attachment that illustrates the sort that I put on the calculated field, based on the Week Begin Date field.  .