View Single Post
  #1   Report Post  
Andy Pope
 
Posts: n/a
Default

Hi,

If the chart is based on all the rows and the chart option Plot Visible
Cells Only is enabled ( Tools Options Chart ) then when the filter
is applied the chart should only display the 100 filtered rows.

Cheers
Andy

Craig wrote:
I have a couple columns of data (about 500 rows). I apply autofilter to that
data, which filters it down to 100 rows of data. These rows are not
sequential. I would only like to plot this filtered list of data in a chart


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info