IsFiltered Property (IChartCategory)

True if the user filters out category. otherwise False.
Property IsFiltered As Boolean
Dim instance As IChartCategory
Dim value As Boolean
instance.IsFiltered = value
value = instance.IsFiltered
bool IsFiltered {get; set;}
By default all the categories in the chart are shown because this property is set to "false". Here for example, we filter out first category 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"].Value = "10";
            sheet.Range["B2"].Value = "20";
            sheet.Range["C2"].Value = "30";
            sheet.Range["A3"].Value = "15";
            sheet.Range["B3"].Value = "25";
            sheet.Range["C3"].Value = "35";
            //Create chart
            IChart chart = sheet.Charts.Add();
            //Set range
            chart.DataRange = sheet.Range["A1:C3"];
            //Set chart type
            chart.ChartType = ExcelChartType.Column_Clustered;
            //Get chart categories collection
            IChartCategories categories = chart.Categories;
            //Get chart first category 
            IChartCategory category = categories[0];
            //Filter out the first category
            category.IsFiltered = true;
            //Save and Dispose

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also