Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Adding Dynamic Vertical reference line to Barchart

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

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      This works as expected.

       

      Thank you for your help.

       

      Regards,

      Rajesh S Hegde