Inside Microsoft Excel

Modify an existing chart to show different data with a little filtering ingenuity

by Frank Kuhn

You’re often dealing with a lot of information, but for purposes of display or analysis, you only need to graph certain elements of it. AutoFilters allow you to dynamically change your charts to show only data that you need, so you can save vital time and effort when charting. Using the AutoFilter feature, you can build parameters into your charts, so that if you only want to see branches that fall within[…]