2 Replies Latest reply on Nov 21, 2014 9:03 AM by Alexis Jasinski

    Create two unique reference lines for every FY quarter

    Alexis Jasinski

      I am trying to add two reference lines (one green, one red) for each quarter. My fiscal year is October-September. I was able to create the view below by creating 5 different sheets. How can I create the same view using one sheet? I have attached a sample packaged workbook.

      I need the fiscal year to be changed to October 1 - September 30th. The unique references per quarter are as followed:

      Q1:

      • Red - 5%
      • Green - 15%

      Q2

      • Red - 30%
      • Green - 40%

      Q3

      • Red - 55%
      • Green - 65%

      Q4

      • Red - 80%
      • Green - 90%

       

      Objective: Create this view in one sheet