Free Support Forum - aspose.com

Setting a series values to "#N/A"

I’m trying to code the error value “#N/A” to a chart series value in Aspose.

Right now the line I’m using, causes the PowerPoint deck to crash. Is there a field I can set a series value to in order to be interpreted as “#N/A” in the embedded excel within a PowerPoint chart (see attached “naChart.png” for an example of what I would like to create programatically)?
fact.GetCell(wksheetIndex,cdv.CategoryId+1,cdv.SeriesId+1,"#N/A");

Thanks much.

Hi Ian,


Thanks for inquiring Aspose.Slides.

I have observed your requirements and like to share that Aspose.Slides offers feature to render the blank values either as zero, span or Gap. Please try using the following sample line in your application and set any of type as per your convenience.

chart.DisplayBlanksAs = DisplayBlanksAsTypeEx.Gap;

Also, you can set the empty values to cells in this regard instead of using N/A.

fact.GetCell(wksheetIndex,cdv.CategoryId+1,cdv.SeriesId+1,String.Empty);

Please share, if I may help you further in this regard.

Many Thanks,

Hey Mudassir,


Thanks this was exactly what I was looking for. So far everything is working great.

Hi Ian,


That is really appreciable that things worked on your end. You are always welcome for your inquiries and please share, if I may help you further in this regard.

Many Thanks,