Microsoft Office Tutorials and References
In Depth Information
Handling missing data
Sometimes, data that you’re charting may be missing one or more data points. As shown in the
accompanying figure, Excel offers three ways to handle the missing data:
Gaps: Missing data is simply ignored, and the data series will have a gap.
This is the default.
Zero: Missing data is treated as zero.
Connect with Line: Missing data is interpolated — calculated by using data on either side
of the missing point(s).
This option is available only for line charts, area charts, and XY charts.