Charting dynamic range

Ok let me say i fully understand how to name a range and in the source data
use the formula =sheetname!rangename

Problem arrises when my macro that runs an advanced filter with the source
data and add data to the bottom of the range the chart reverts back to it's
initial data source =sheet1!$a$4:$b$15

so even though it accept the named range intitailly once the advanced filter
runs it almost ommits the named range. I am using 2007 and i never had this
problem in 2003.

What suggestions do you have for me?
Thank you!!!!!
--
Thank you,

Jennifer