Microsoft KB Archive/60996

{|
 * width="100%"|

Lines Between Data Points Not Appearing in Excel

 * }

-

The information in this article applies to:


 * 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 :

Technology :