Article ID: 884406 - Last Review: August 21, 2009 - Revision: 4.0 A Line chart may plot gaps in lines when the data range contains blank cells in ExcelOn This PageSYMPTOMSWhen you create a Line chart in Microsoft Excel, the chart may contain a gap in a line. CAUSEThis issue may occur when the data range for the Line chart contains a blank cell. WORKAROUNDTo work around this issue, use one of the following methods. Method 1Plot empty cells as interpolated. To do this, follow these steps:Excel 2000 - 2003
Excel 2007
Method 2Use the NA function in the blank cell of the chart's data range. To do this, use one of the following methods:
| Article Translations
|
Back to the top
