Imagine This: You have a Sales chart displaying your particular transactions. Everything looks good until you are looking at unfilled, future dates – it looks as though your company has gone off the map! Today, in Episode #1704, Bill “MrExcel” Jelen shows us how to deal with the ‘Drop to Zero’ issue for future dates in our Chart.

[youtube=http://youtube.com/watch?v=Gzx-xYWkmfw]

Charts and Graphs 2013 by Bill Jelen

For more information on Charts and Graphs in Excel 2013, see bill Jelen’s new book “Excel 2013 Charts and Graphs“. 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!

This book reveals data visualization techniques you won’t find anywhere else and shows you how to use Excel 2013 to create designer-quality charts and graphs that stand out from the crowd.

and

"Charts And Graphs: Microsoft Excel 2010" by Bill Jelen for more information on Charts and Graphs in Excel 2010, see the book, “Charts And Graphs: Microsoft Excel 2010“, by Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com– Your One Stop for Excel Tips and Solutions.