Learn Excel Episode 643: Excluding Zero Values From Pie Charts

Posted in Companies, Podcasts on July 12, 2008


Learn Excel Episode 643: Excluding Zero Values From Pie Charts

Patrick wrote in to address my answer from podcast 641. In that podcast, I used a SUMIF to create a pie chart of hours spent by department. Patrick notes that early in the month, many of the departments have 0 values and would like those excluded from the chart. In Episode 643, I set up a series of formulas to sort the data and then a named range to exclude the zeroes from the chart.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel