# Display N/A Values

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

## Content

DsExcel.NET provides support to display #N/A cells as empty cells in charts. The [DisplayNaAsBlank](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.Drawing.IChart.DisplayNaAsBlank.html) property of [IChart](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.Drawing.IChart.html) interface, when set to true, considers the cells containing #N/A values as empty cells. When DisplayNaAsBlank property is set to **true**, the display of empty cells, when plotted on a chart depends on the value of [DisplayBlanksAs](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.Drawing.IChart.DisplayBlanksAs.html) 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**\- \#N/A values are shown as 'interpolated' in the chart
* **NotPlotted**\- \#N/A values are shown as 'gaps' in the chart
* **Zero** \- \#N/A values are shown as 'zero' in the chart

The below screenshot depicts a chart created from data containing #N/A cells which is displayed as zero because value of DisplayBlankAs is set to 'Zero'.
![](https://cdn.mescius.io/document-site-files/images/e333ad47-35da-43f9-a389-25433765f491/images/display-na-as-blank.png)
Following code demonstrates a line chart showing values plotted with **DisplayNaAsBlank** set to true.

```csharp
// Set show blank as zero.
shape.Chart.DisplayBlanksAs = DisplayBlanksAs.Zero;
        
// Set show #N/A as empty cell.
shape.Chart.DisplayNaAsBlank = true;
shape.Chart.ChartTitle.Text = "DisplayNaAsBlank:True";
```

When DisplayNaAsBlank property is set to **false**, chart plots the #N/A values depending on the chart type.