Syncfusion.XlsIO.Base
Example 


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.
Syntax
'Declaration
 
Property PlotVisibleOnly As Boolean
'Usage
 
Dim instance As IChart
Dim value As Boolean
 
instance.PlotVisibleOnly = value
 
value = instance.PlotVisibleOnly
bool PlotVisibleOnly {get; set;}
Example
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
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also