Dealing with missing data in a line chart

Book cover This article is an excerpt from John Walkenbach's Favorite Excel 2007 Tips & Tricks by John Walkenbach. A.k.a. Mr. Spreadsheet, John is arguably the foremost authority on Excel. His forty-plus books include Excel 2007 Power Programming with VBA, Excel 2007 Formulas, and the bestselling Excel 2007 Bible, all published by Wiley. He has also written hundreds of articles and created the award-winning Power Utility Pack. Visit Wiley.com to learn more about this book.

When you create a line chart in Excel, missing data points (blank cells) aren’t plotted, which leaves gaps in the chart. Excel provides two other ways of handling missing data. Find the details in the following article.

Read Article button

Applies To: Excel 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language