How can I update a graph with autofiltered data?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to be able to set up graphs which will update automatically once
differed filters are applied using autofilter. Can this be done?
 
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/
_______
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert multiple .dat files into one pdf without losing color of their graphs 0
VBA: How can I use a string variable as autofilter criteria? 4
Numbering after using autofilter 10
Auto Filter value 1
Autofilter not grabbing last row 1
Counting Filtered Results Using Autofilter 2
how can I make autofilter automatically update 2
Count the number of AutoFiltered records 6

Back
Top