Hello,
I have a PivotChart whose data source is the entire worksheet, however I want to change the data source to exclude any filtered out columns/rows. Is there a function to do so, such as a true value or filtered value for the chart data source?
thank you!