2 Replies Latest reply: May 11, 2018 8:42 AM by youssef belloum RSS

    Add On's / Reference Lines

    Neale Forth

      Hi QS Community,

       

      I have a stacked line chart - see attached pic - and I am trying to add a reference line to it. ( I have drawn this on the attached example - rather badly in black !)

       

      The reference line is our prediction of what will happen and is a complicated process to calculate using probability - so ideally I am trying to over lay a line on this chart without calculating this in a expression.

       

      I can use Add Ons / Reference Line to add in a flat reference line of 600 per quarter, however our prediction line is variable 600/700/900/1250/400/300 and so on...

       

      Stacked Chart.PNG

      Any ideas how I can achieve this variable reference line ?

       

      Many thanks,

       

      Neale