charting a filtered list

  • Thread starter Thread starter cathyh
  • Start date Start date
C

cathyh

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.
 
Select chart, go to Tools menu > Options > Chart tab, check Plot Visible
Cells Only.

- Jon
 
Back
Top