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...
Any ideas how I can achieve this variable reference line ?