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.

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


Des Wrote:
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
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=393206