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
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!