Episode 783 - Hide Zeroes

Back in Episode 767, the pod dealt with the problem of using =IF(ISBLANK(A2),"",A2) to hide zero values in the results table. Today, Rene and Denis both write in with a far simpler solution. Episode 783 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 776 - Interactive Chart

Lucy asks how to make a chart interactively change from red to yellow to green based on an external selection. In today's Episode 776, we take a look at the basics of setting up such a chart. Tomorrow's episode will take a look at the Options button on the Form toolbar to enhance the chart.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!