By default, charts do not display hidden data. When you apply an autofilter
to the data, the hidden rows are not plotted.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
"Scotty" wrote in message
...
I want to be able to set up graphs which will update automatically once
differed filters are applied using autofilter. Can this be done?