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!
Bookmarks