I should also mention that I've seen the posts about setting the Chart
Options to plot empty cells as 'Not plotted' (which has no effect) and
'Interpolated' (which is not enabled), so this seems to be no help.