Make data not accessible for formula

Hi,

I have this excel sheet(A) that is reading my other excel sheet(B) and then it produces graphs. The data (In sheet A) that I insert are corresponding to a certain date. I want to filter it by month, so when I update it, the new sheet(B) and graph will adjust the data. But right now, if I hide or filter my data (in sheet A) and make it invisible, the new sheet (B) and graph don't change at all becuse the hidden data are still accessible by the formula. Is there anyway to make the hidden data not accessible for formula to grab ?