Syncfusion.XlsIO Namespace > IChart Interface : PlotVisibleOnly Property

PlotVisibleOnly Property (IChart)

True if only visible cells are plotted. False if both visible and hidden cells are plotted.
Property PlotVisibleOnly As Boolean
Dim instance As IChart
Dim value As Boolean
instance.PlotVisibleOnly = value
value = instance.PlotVisibleOnly
bool PlotVisibleOnly {get; set;}
By default PlotVisibleOnly property is set to "true" so only cells which are visible within the chart's DataRange will be plotted in chart. Here for example, we set PlotVisibleOnly to "false" so that chart plots all the cells within the chart's DataRange.
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["B2"].Value = "20";
            sheet.Range["C2"].Value = "30";
            //Hide column
            sheet.Columns[2].ColumnWidth = 0;
            //Create chart
            IChart chart = sheet.Charts.Add();
            //Set range
            chart.DataRange = sheet.Range["A1:C2"];
            //Set Plot visible only
            chart.PlotVisibleOnly = false;
            //Save and Dispose

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also