Dynamic Chart Range working but chart not updating

Hi, i create a sample as per attached. I wanted the Chart to show only data that i put a "Yes" beside. I have use formula to generate the Net Data (using Name Manager (OFFSET formula) which shd be reflected in the Bar Chart.
However, when i remove/add Yes, i c that my Name Manager range work. BUt when the chart is not updating.

Anyone can advice why is this so?