Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scotty
 
Posts: n/a
Default How can I update a graph with autofiltered data?

I want to be able to set up graphs which will update automatically once
differed filters are applied using autofilter. Can this be done?
  #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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 02:56 PM
adding data table with different data to a graph ratio Charts and Charting in Excel 1 June 17th 05 05:24 PM
Help making a chart that doesn't graph cells without data? Filtration Guy Excel Discussion (Misc queries) 0 March 22nd 05 10:21 PM
Charts don't update when data changes Annetrude de Mooij Charts and Charting in Excel 0 February 9th 05 02:53 PM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 06:19 PM


All times are GMT +1. The time now is 03:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"