5 Replies Latest reply: Mar 12, 2013 4:34 AM by Sorcha Collins RSS

    How to stop two lines appearing on the one graph for the one calculation?

      Hi,

       

      I have a line chart with sales figures for the last twelve months, calculated on a rolling period.

      For example, we are now in March 2013 so the chart dates back to April 2012, and updates each month.

       

       

      I have one expression, the Actual figures for the last twelve months, which is made on a variable.

       

      The chart is now displaying two lines within the chart for the actual figure instead of one line.

       

      See Example below;

       

      Has anyone any idea how to fix this so that only one line appears?

       

      Capture.PNG