Skip Blanks when Graphing in Microsoft Excel

Recently I tried graphing in Microsoft Excel but the data that I was graphing had some blank cells and thus the chart was not graphing it well. In this video I go over how Excel deals with graphing as well as calculating cells that include blanks and error values. I also show how you can use the #N/A error value to skip blanks when graphing as well as using the IF() and the ISERROR() functions to deal with calculating functions that include the #N/A (or NA() function) values. This is very important when you have to present data in charts using Excel so make sure to watch this video!

Download the notes in my video:

Excel File: https://www.dropbox.com/s/1yxo5zivgmkglry/303%20-%20Skip%20Blanks%20in%20Excel%20Chart.xlsx PDF Notes: https://www.dropbox.com/s/nvz2rwtaxaau513/303%20-%20Skip%20Blanks%20in%20Excel%20Chart.pdf

Related Videos:

Convert Time to number, seconds, hours and minutes in Microsoft Excel 2007: http://youtu.be/fwMKbXI98tI Converting Numbers to Fractions in Microsoft Excel 2007: http://youtu.be/YgJBK0QjIec Drop Down Lists with Microsoft Excel 2007: http://youtu.be/e7Sbcn-y9j4 Can't copy and paste hyperlinks to Office Word?? Try Closing Internet Explorer: http://youtu.be/FczySOM59VQ Showing Heading Levels in Table of Contents - Office Word 2007: http://youtu.be/psGZmT1mHzE .

SUBSCRIBE via EMAIL: https://mes.fm/subscribe

DONATE! ʕ •ᴥ•ʔ https://mes.fm/donate

Like, Subscribe, Favorite, and Comment Below!

Follow us on:

Official Website: https://MES.fm Steemit: https://steemit.com/@mes Gab: https://gab.ai/matheasysolutions Minds: https://minds.com/matheasysolutions Twitter: https://twitter.com/MathEasySolns Facebook: https://fb.com/MathEasySolutions LinkedIn: https://mes.fm/linkedin Pinterest: https://pinterest.com/MathEasySolns Instagram: https://instagram.com/MathEasySolutions Email me: contact@mes.fm

Try our Free Calculators: https://mes.fm/calculators

BMI Calculator: https://bmicalculator.mes.fm Grade Calculator: https://gradecalculator.mes.fm Mortgage Calculator: https://mortgagecalculator.mes.fm Percentage Calculator: https://percentagecalculator.mes.fm

Try our Free Online Tools: https://mes.fm/tools

iPhone and Android Apps: https://mes.fm/mobile-apps ... https://www.youtube.com/watch?v=HcCJVUd7a5Q