homeHome contactContact portfolioPortfolio musicMusic videoVideo historyHistory calendarCalendar rssLinks rssRSS


.. Behind every succesfull man is a woman with nothing to wear ..

MrExcel’s Learn Excel #1004 – Charting Zero

June 4th, 2009 learn accounting

Glenn has a series of line charts showing monthly data for 2009. Most charts work fine, but the total chart shows the line dropping to zero for future months. Episode 1004 shows how to solve this problem, then how to solve the problem from the solution to the original problem!

This video is the 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!

Duration : 0:3:26


Dueling: Average Non-Zeroes -1030- Learn Excel from MrExcel

Share and Enjoy:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Blogplay

Technorati Tags: , , , , , , ,

One Response to “MrExcel’s Learn Excel #1004 – Charting Zero”

  • ExcelIsFun 04Jun09

    Dear Bill Mr Excel …
    Dear Bill Mr Excel Jelen,

    That is a cool trick!

    –excelisfun

Leave a Reply









XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>





Archives

Meta

Meta Data