4 Replies Latest reply: May 12, 2017 9:13 AM by Lucas Westmaas RSS

    Trend line chart - null values

    Lee Van Scoy

      Hi -


      This is my chart. The red and green lines are prior year and budget. I want to show prior year and budget for all 12 months. The blue line represents actuals. I only want the blue line to show through the current month (not display if the value is 0). We are in month 2 of our fiscal year, so it shouldn't show values after month 2, until there are values to show.

      Please help! Thank you!