Syncfusion.XlsIO.Base
Example 


Syncfusion.XlsIO Namespace > IChart Interface : DisplayBlanksAs Property

DisplayBlanksAs Property (IChart)

Gets or sets a value indicating how the blank cells are plotted on chart.
Syntax
'Declaration
 
Property DisplayBlanksAs As ExcelChartPlotEmpty
'Usage
 
Dim instance As IChart
Dim value As ExcelChartPlotEmpty
 
instance.DisplayBlanksAs = value
 
value = instance.DisplayBlanksAs
ExcelChartPlotEmpty DisplayBlanksAs {get; set;}
Example
If cells within the chart's DataRange has no data then those are not plotted in charts. Because by default the DisplayBlanksAs is set to ExcelChartPlotEmpty.NotPlotted. Here for example, we set ExcelChartPlotEmpty.Zero to DisplayBlanksAs property.
using Syncfusion.XlsIO;
             
class Program
{
    static void Main(string[] args)
    {
        using (ExcelEngine excelEngine = new ExcelEngine())
        {
            //Create worksheet
            IApplication application = excelEngine.Excel;
            application.DefaultVersion = ExcelVersion.Excel2013;
            IWorkbook workbook = application.Workbooks.Create(1);
            IWorksheet sheet = workbook.Worksheets[0];
            
            //Add data
            sheet.Range["A1"].Text = "Jan";
            sheet.Range["B1"].Text = "Feb";
            sheet.Range["C1"].Text = "Mar";
            sheet.Range["A2"].Value = "10";
            sheet.Range["C2"].Value = "30";
                                                
            //Create chart
            IChart chart = sheet.Charts.Add();
             
            //Set range
            chart.DataRange = sheet.Range["A1:C2"];
             
            //Set chart type
            chart.ChartType = ExcelChartType.Column_Clustered_3D;
             
            //Set display as
            chart.DisplayBlanksAs = ExcelChartPlotEmpty.Zero;
             
            //Save and Dispose
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also