I would suggest you review this essay: http://peltiertech.com/mind-the-gap-...g-empty-cells/ Having a formula return #N/A error value is usually better for line and scatter charts.