FIlter by value for finding Standard deviation

Hi All,


I have a line chart with Month on the X axis and Time on the y axis. The lines are colored baed on the project task.

I added an average and upper and lower control limit lines based on standard deviation+3 and -3.

is it possible for me to add a filter (column like 1,2,3) and change the std deviation like when i select 1 the control limit lines should change accordingly?

(1) Answer