Select chart, go to Tools menu Options Chart tab, check Plot Visible
Cells Only.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"cathyh" wrote in message
...
is it possible to chart a list that has been filtered via autofilter? my
chart shows all data; even from the rows that the filter has hidden.