I traced precedents to find a formula to apply a SUBTOTAL/OFFSET component to. I changed the formula in 'FX Trade Log' K14 to this and filled down. Then applied filter to the dates in 'FX Trade Log'. The chart updates. Check that it updates as expected. You may want to apply the SUBTOTAL/OFFSET to another formula instead.
If you are not familiar with SUBTOTAL it has several functions. COUNTA (3 or 103) is one of them. It will ignore invisible / hidden values. That effect carries over to column T 'FX Equity Chart'.
Bookmarks