You helped me but not like you would expect. I did something very stupid. I
first applied the fiter on my data and then created the chart. Afterwords i
expected my chart to update every time i changed my filter criteria, which of
cource didn't happen.
Solved it by selecting all data for my chart and applying the filter AFTER.
Nevermind the second leg of my question. Solved that too.

Thanks.