Chart filtering

[tgrs12]

Hi all! I have a workbook with multiple charts. I set up multiple named ranges to make the charts automatically update. However, there are a couple of charts that used chart filters for the horizontal axis before setting up named ranges, and after setting up the name ranges, the option to filter the chart is not available. Is there a way around this without having to adjust the data and workbook setup? Basically, I want to be able to filter the chart’s horizontal axis while using named ranges as the data feeding the chart. Thank you!

[Andy Pope]

Without seeing your workbook and how you have actually set it up it's impossible to say.

Post example workbook, which demonstrates the issue, using the instructions in the yellow banner at the top of the page.