Document Solutions for Excel, .NET Edition | Document Solutions
Features / Chart / Customize Chart Objects / Series / Display Empty Cells
In This Topic
    Display Empty Cells
    In This Topic

    While plotting data on charts, you may have to deal with visualization of blank or empty cells on them. Depending on the requirement, you may want to plot empty values as gaps, zero or connected lines on the chart. This feature is helpful in plotting the missing data in a chart and hence facilitates users in quickly identifying and correcting any issues with the data.

    Similar to Excel, DsExcel provides support for displaying empty cells and null values in charts using DisplayBlanksAs property. The property accepts values from DisplayBlankAs enumeration and can have following three values:

    This property is especially useful when DisplayNaAsBlank property is set to true. For more information, see Display #N/A Values.

    Below images demonstrate how a daily rainfall chart is plotted with value against Day 4 as blank when DisplayBlankAs property is set to NotPlotted, Zero or Interpolated.

    DisplayBlankAs = NotPlotted DisplayBlankAs = Zero DisplayBlankAs = Interpolated

     Using Code

    Below code shows how to set DisplayBlankAs property to plot blank values as zero.

    C#
    Copy Code
    // Set show blank as zero.
    shape.Chart.DisplayBlanksAs = DisplayBlanksAs.Zero;