Today, Mike and Bill address the “Drop to Zero” problem in a Chart. This time, because it is a Stacked Line Chart and the =NA() trick isn’t working here. Follow along with Episode #1712 as Mike “ExcelisFun” Girvin and Bill “MrExcel” Jelen work out solutions to this ‘Drop to Zero’ issue. Also, be sure to visit Episode #1704 for different approaches for single Line charting).

[youtube=http://youtube.com/watch?v=NXypnC0VjlI]

Dueling Excel Podcast #124…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle]

and

Charts and Graphs 2013 by Bill Jelen…for Chart and Graph information? Use Excel 2013’s radically revamped charting and graphing tools to communicate more clearly, powerfully, and quickly… so you drive your message home, and get the decisions and actions you’re looking for! Charts and Graphs Excel 2013 by Bill Jelen

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!