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. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Pyro TV | November 29, 2007

Tags:. .blog. .every. .create. .minute. .business