“Excel, did you know?” that you can filter a table using Advanced Filter, and if a chart is connected to data in that table the chart data will also be filtered (2013 version).
“Excel did you know?” Tip#1
Leave a reply
“Excel, did you know?” that you can filter a table using Advanced Filter, and if a chart is connected to data in that table the chart data will also be filtered (2013 version).