MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Chart FILTER


May 07, 2017 - by Bill Jelen

Chart FILTER

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

Title Photo: sign/post/53042c4d-51c8-4c6c-b8be / Pixabay


Bill Jelen is the author of
Excel Subtotals Straight to the Point

I used to use the Subtotals feature daily after downloading mainframe data. This book covers every tip and trick for using Subtotals.