View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jon Peltier
 
Posts: n/a
Default How can I update a graph with autofiltered data?

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?