IsFiltered Property (IChartSerie)

Gets or sets a boolean value indicating whether the series has been filtered out from the chart.
Property IsFiltered As Boolean
Dim instance As IChartSerie
Dim value As Boolean
instance.IsFiltered = value
value = instance.IsFiltered
bool IsFiltered {get; set;}
By default all the series in the chart are shown because IsFiltered property is set to "false". Here for example, we set first serie IsFiltered property to "true" so it is filtered out from the chart and it will not be shown in the chart.
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"].Text = "Apr";
            sheet.Range["B2"].Text = "May";
            sheet.Range["C2"].Text = "Jun";
            sheet.Range["A4"].Value = "10";
            sheet.Range["B4"].Value = "20";
            sheet.Range["C4"].Value = "30";
            sheet.Range["A3"].Value = "15";
            sheet.Range["B3"].Value = "10";
            sheet.Range["C3"].Value = "35";
            //Create chart
            IChart chart = sheet.Charts.Add();
            //Set range
            chart.DataRange = sheet.Range["A1:C4"];
            //Set chart type
            chart.ChartType = ExcelChartType.Line;
            //Set IsFiltered
            chart.Series[0].IsFiltered = true;
            //Save and Dispose

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also