Episode # 643 - Excluding Zero Values From Pie Charts
Sponsored by
Check out this book for more tips
similar to this lesson!
Thursday, November 29, 2007
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.
You don't need to go spend an entire day at the local computer chain store to learn Excel. Take 4 minutes to learn this lesson now with our free video!
Tags/Keywords for this video: Charts
More Excel Video Lessons
If you like this video, there are hundreds of 2-5 minute videos available here:
- Excel training videos about Charts
- Excel training videos about VBA
- Excel training videos about Pivot Tables
- Excel training videos about Data Analysis
- Excel training videos about Formulas
- Excel training videos about Formatting
- Excel training videos about Printing
- Excel training videos about Excel 2007
- Excel Video Lessons Index
