Hi Erik,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
Thank you for considering Aspose.
We think the best way is making the cell empty if the value of the cell is zero. Please see the following sample code in this regard:
Workbook workbook = new Workbook();
Cells cells = workbook.Worksheets[0].Cells;
cells["A1"].PutValue(1);
cells["A2"].PutValue(0);
cells["A3"].PutValue(3);
Charts charts = workbook.Worksheets[0].Charts;
int index = charts.Add(ChartType.Column3DClustered, 5, 0, 15, 5);
Chart chart = charts[index];
chart.NSeries.Add("A1:A3", true);
chart.NSeries[0].DataLabels.IsValueShown = true;
cells["A2"].PutValue(null);
workbook.Save(@"C:\dest.xls");
Thank You & Best Regards,