ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can I update a graph with autofiltered data? (https://www.excelbanter.com/excel-worksheet-functions/86863-how-can-i-update-graph-autofiltered-data.html)

Scotty

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?

Jon Peltier

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?





All times are GMT +1. The time now is 04:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com