Bug - Empty Cells Plotted as Zero

If you include empty cells in your source data, the default behaviour is to ignore these are to show gaps in your series

Description:

You can change this behaviour by displaying the "Hidden and Empty Cells" on the Select Data Source dialog box
SS
Click on "Hidden and Empty Cells" on the Select Data Source dialog box
When you import data or copy data from other applications a cell might seem to be empty but infact it isnt.
In this case your chart will plot the empty cells as zero.