I am having trouble in finding the right function to keep the selection in a chart. I have a chart displaying Fill Rate for years 2013, 2014, 2015, 2016, and the GOAL. The users want to see only the Goal and 2016 as default. But if they select 2013, 2014 and so on, the line for that year will appear in the chart. I am using the function below and I tried several different combinations, but nothing worked. When one year is selected, that year appears, but as soon as I select another year, it disappears.
Both of these ideas are good ideas, but only work partially. The syntax from Jagan, it displays the max year selected. I need to be able to select 2013 and still show 2014 and/or 2015 in another line. This syntax gives me only max year.
The syntax from Balraj, is similar to what I have, and I can show 2013 when selected, but when I make another selection, for example 2013 and 2014, 2013 disappear.
I need to have different lines for each year, with capability of checking them in or out, as in a check box.