Chart FILTER

May 07, 2017 - by Bill Jelen

Today's trick from Lisa in Indianapolis is a faster way to filter a chart

Watch Video

Today's trick from Lisa in Indianapolis is a faster way to filter a chart
You can filter a chart to just one customer, one sales rep, one anything.
You used to do this by filtering the original data set.
But, starting in Excel 2013, you can use the Funnel/Filter icon to the right of the chart.
Bonus tip today: Excel offers an odd Font dialog with things like:
ALL CAPS, Double Strikethrough, and more

Download File

Download the sample file here: Podcast2092.xlsm