View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default charting a filtered list

Select chart, go to Tools menu Options Chart tab, check Plot Visible
Cells Only.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"cathyh" wrote in message
...
is it possible to chart a list that has been filtered via autofilter? my
chart shows all data; even from the rows that the filter has hidden.