How can I update a graph with autofiltered data?

S

Scotty

I want to be able to set up graphs which will update automatically once
differed filters are applied using autofilter. Can this be done?
 
J

Jon Peltier

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/
_______
 
Top