Auto Filter problem

[Des]

Hi I'm using auto filter to view chart easier, when ever I drag down the row
I want, the chart will plot exactly what I need.
OK. Problem is, it only allow me to drag down once, after that, the auto
filter can not filter any more.

Any thought? Thanks in advance.

 

[Morrigan]

If you have more than one criteria, try advanced filter.