Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
On chart properties>Presentation>right bottom>under reference lines you can add it