Adding Dynamic Vertical reference line to Barchart

[Anonymous]

Hi All, 

My dataset is as below.

Result Type	Age - Forecasted(Month)	Age - Current (Month)	Qty
NOMINAL	60	30	184817.997
NOMINAL	48	30	160860.2616
NOMINAL	36	30	135505.1271
NOMINAL	24	30	81276.15796
NOMINAL	18	30	67475.59567
NOMINAL	12	30	40034.11791
NOMINAL	9	30	33119.86705
NOMINAL	6	30	26202.99104
NOMINAL	3	30	19271.68226
UPPER_BOUND	60	30	377972.0389
UPPER_BOUND	48	30	328794.7661
UPPER_BOUND	36	30	276670.6652
UPPER_BOUND	24	30	165593.4012
UPPER_BOUND	18	30	137292.0072
UPPER_BOUND	12	30	81319.0919
UPPER_BOUND	9	30	67214.44798
UPPER_BOUND	6	30	53133.68476
UPPER_BOUND	3	30	39054.3245

Where Result type is Legend, Forecasted Age is coming from forecasted data and it will be always ranging from 3-60. Age - Current  in Month is the actual age which will be dynamic based on the selection of the filter. The bar represents Sum of Qty for each Result Type. So chart will look like below.

This is the current chart

Now I want to add a reference line which will represnt the column 'Age - Current  in Month' and bar graph should show like this.

This is the expected chart

Please help me to resolve this issue.

Thanks,

Rajesh S Hegde

[mwegener · Accepted solution]

Hi @Anonymous ,

maybe the attached solution works for you.

[Anonymous]

This works as expected.

Thank you for your help.

Regards,

Rajesh S Hegde