Help and Support
 

powered byLive Search

A Line chart may plot gaps in lines when the data range contains blank cells in Excel

Article ID:884406
Last Review:September 6, 2006
Revision:2.2
On This Page

SYMPTOMS

When you create a Line chart in Microsoft Excel, the chart may contain a gap in a line.

Back to the top

CAUSE

This issue may occur when the data range for the Line chart contains a blank cell.

Back to the top

WORKAROUND

To work around this issue, use one of the following methods.

Back to the top

Method 1

Plot empty cells as interpolated. To do this, follow these steps:
1.Click your Line chart to start it.
2.On the Tools menu, click Options.
3.On the Chart tab, click Interpolated, and then click OK.

Back to the top

Method 2

Use the NA function in the blank cell of the chart's data range. To do this, use one of the following methods:
In the blank cell, type #N/A.
In the formula bar for the blank cell, type =NA().
If the cell range for the Line chart uses a formula to obtain values from a different cell range, and if you do not want the Line chart to plot 0 (zero), type the following formula in the formula bar:
=IF(SUM(range)=0,NA(),SUM(range))
Note range is the cell range that is outside the cell range for the Line chart.

Back to the top


APPLIES TO
Microsoft Office Excel 2003
Microsoft Excel 2002 Standard Edition
Microsoft Excel 2000 Standard Edition

Back to the top

Keywords: 
kbchart kbtshoot kbprb KB884406

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.