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
You can change this behaviour by displaying the "Hidden and Empty Cells" on the Select Data Source dialog box
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.
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext