# Display N/A Values

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

## Content



DsExcel Java provides support to display #N/A cells as empty cells in charts. The [setDisplayNaAsBlank](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/drawing/IChart.html#setDisplayNaAsBlank) method of [IChart](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/drawing/IChart.html) interface, when set to true, considers the cells containing #N/A values as empty cells. When setDisplayNaAsBlank is set to **true**, the display of empty cells, when plotted on a chart depends on the value of [setDisplayBlanksAs](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/drawing/IChart.html#setDisplayBlanksAs) method. The method accepts values from [DisplayBlanksAs](/document-solutions/java-excel-api/api/online/com/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 DisplayBlanksAs is set to 'Zero'.

![](https://cdn.mescius.io/document-site-files/images/dd59ea42-cd61-4fa6-a018-6231c2a9c598/images/display-na-as-blank.png)

Following code demonstrates a line chart showing values plotted with setDisplayNaAsBlank set to true.

```Java
// Set show blank as zero.
shape.getChart().setDisplayBlanksAs(DisplayBlanksAs.Zero);

// Set show #N/A as empty cell.
shape.getChart().setDisplayNaAsBlank(true);
shape.getChart().getChartTitle().setText("DisplayNaAsBlank:True");
```

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