Lines Between Data Points Not Appearing in Excel

• Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0, 5.0c
• Microsoft Excel for OS/2, versions 2.2, 3.0
• Microsoft Excel for Windows 95, versions 7.0, 7.0a

SUMMARY

When plotting an Microsoft Excel line chart with a blank cell in the middle of the range of cells, Microsoft Excel does not routinely plot a connecting line between the breaks in the data.

MORE INFORMATION

To connect the data points, place the formula =NA() in the blank cell(s), or in an if statement [for example, =IF(SUM(range)=0,NA())]. When Excel plots the data, the chart will be created without a break in the plot line.

Please note that this method is valid only if the cell is in the middle of a range of data. It will not work if the cell is at one end of the range.

Additional query words: 2.0 2.00 2.01 2.1 2.10 3.0 4.0

Keywords          : 
Version           : 
Platform          : 
Issue type        : 

Last Reviewed: March 16, 1999