ExcelBanter - charting a filtered list

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - charting a filtered list (https://www.excelbanter.com/charts-charting-excel/190105-charting-filtered-list.html)

CathyH

charting a filtered list

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.

Jon Peltier

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.

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