4 Replies Latest reply: Apr 16, 2015 5:13 AM by Rhona Corcoran RSS

    Chart showing previous years

    Rhona Corcoran

      Hi

       

      Looking for help with a line chart

       

      I have attached a file with two line charts.  It is supposed to show this year V previous 2 years and target.

       

      Chart 1 is doing this but the expressions are hard coded with the years.  What I really want is like Chart 2 which is working fine if 2014 is selected but when 2015 is selected because there is no data in yet for 2015 it is not showing any of the years.  So I need this to show the previous years even if there is no data in the current year.

       

      Any help would be appreciated

       

      Thanks