1 Reply Latest reply: May 31, 2017 5:50 AM by Taj Mohamed RSS

    Make a diagonal, linear reference line for accumulated values

    Hugo Wortel

      Hi!

       

      For each of the countries we deliver to, we have set total estimated sales (TES) for this year. Like this:

       

      Country     Total estimated sales in 2017

      X               12.000.000

       

      We have a bar chart in which we show the accumulated monthly sales for this year. To show if the accumulated monthly sales meet the accumulated monthly ESTIMATED sales I would like to add a linear (diagonal) reference line which shows the accumulated estimed monthly sales ((TES/12)*month number).

       

      I would like to this without adding a measure to my chart and just make use of the reference line function.

       

      Any ideas to solve this are much appreciated!

       

      Regards,

       

      Hugo