Forum Discussion
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
Hi Anonymous ,
maybe the attached solution works for you.
2 Replies
- mwegenerMost Valuable Professional
- AnonymousNot applicable
This works as expected.
Thank you for your help.
Regards,
Rajesh S Hegde