Problem with Using Variable Named Range for Chart

I created a Variable named range based on choices on Summary tab. This works. Created Chart using ChartData (the variable Named Range). Good. But then when the options are changed. The chart doesn't change.
So for example - when creating the chart, the options in the variable range result in a range of A1:F10. When I change the options and the range would result in A1:F30 - the chart remains A1:F10.

Example Worksheet attachedTEST.xlsm

Looks like the chart changes as expected to me with the possible exception of the legend having some unused symbols when changing from All to another selection under Year.
Could you please give us a specific instance where it does not.
Such as when changed from Expanded Income to Profit, or from All to Last 3, what should it do that it isn't?

Fixed it with Macros. On sheet Summary when B2 or D2 changes, then it runs a macro that updates the data based on the variable Named Range. By updating everything each time, you don't get the unused symbols. What was happening before, if you chose an option that had less data, the next change you made would not have all the data you want - or if you chose an option that had more data, you get the unused symbols. So it would use the variable Named range for the first choice, but would not update the range for the second...
The macro updates the range each time a change is made.
On summary:

Please Login or Register  to view this content.

On Module:

Please Login or Register  to view this content.

TEST.xlsm