Excel - copy only filtered data and chart
When filtering data and you want to only use the data shown, copy and paste will display all the hidden data. This method applies either to filtered data or using the subtotal function. You can use a Pivot Table/Chart to perform this, however this method is a bit simpler.