# Display Empty Cells

DsExcel is a Document Solutions product that offers a comprehensive library to create, manipulate, convert, and share Microsoft Excel-compatible spreadsheets.

## Content

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](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.DisplayBlanksAs.html) enumeration and can have following three values:

* **Interpolated**\- Blank values are shown as 'interpolated' in the chart
* **NotPlotted**\- Blank values are shown as 'gaps' in the chart
* **Zero** \- Blank values are shown as 'zero' in the chart

This property is especially useful when **DisplayNaAsBlank** property is set to true. For more information, see [Display #N/A Values](/document-solutions/dot-net-excel-api/docs/online/Features/UseChart/CustomizeChartObjects/Series/display-na-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** |
| --------------------------- | --------------------- | ----------------------------- |
| ![](https://cdn.mescius.io/document-site-files/images/e333ad47-35da-43f9-a389-25433765f491/images/display-na-as-blank-notplotted.png) | ![](https://cdn.mescius.io/document-site-files/images/e333ad47-35da-43f9-a389-25433765f491/images/display-na-as-blank-zero.png) | ![](https://cdn.mescius.io/document-site-files/images/e333ad47-35da-43f9-a389-25433765f491/images/display-na-as-blank-interpolated.png) |

## Using Code

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

```csharp
// Set show blank as zero.
shape.Chart.DisplayBlanksAs = DisplayBlanksAs.Zero;
```