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



      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!