Applying Chart Filters Using Essential XlsIO | Syncfusion Blogs
Live Chat Icon For mobile
Live Chat Icon
Popular Categories.NET  (181).NET Core  (28).NET MAUI  (227)Angular  (113)ASP.NET  (49)ASP.NET Core  (81)ASP.NET MVC  (87)Azure  (42)Black Friday Deal  (1)Blazor  (236)BoldSign  (14)DocIO  (24)Essential JS 2  (110)Essential Studio  (200)File Formats  (73)Flutter  (136)JavaScript  (226)Microsoft  (122)PDF  (83)Python  (1)React  (105)Streamlit  (1)Succinctly series  (131)Syncfusion  (964)TypeScript  (33)Uno Platform  (3)UWP  (3)Vue  (46)Webinar  (53)Windows Forms  (59)WinUI  (72)WPF  (163)Xamarin  (159)XlsIO  (38)Other CategoriesBarcode  (5)BI  (29)Bold BI  (8)Bold Reports  (2)Build conference  (11)Business intelligence  (55)Button  (4)C#  (164)Chart  (147)Chart of the week  (58)Cloud  (15)Company  (440)Dashboard  (8)Data Science  (3)Data Validation  (8)DataGrid  (73)Development  (681)Doc  (7)DockingManager  (1)eBook  (99)Enterprise  (22)Entity Framework  (7)Essential Tools  (13)Excel  (43)Extensions  (23)File Manager  (7)Gantt  (21)Gauge  (12)Git  (5)Grid  (31)HTML  (13)Installer  (2)Knockout  (2)Language  (1)LINQPad  (1)Linux  (2)M-Commerce  (1)Metro Studio  (11)Mobile  (522)Mobile MVC  (9)OLAP server  (2)Open source  (1)Orubase  (12)Partners  (21)PDF viewer  (45)Performance  (13)PHP  (2)PivotGrid  (5)Predictive Analytics  (6)Report Server  (3)Reporting  (8)Reporting / Back Office  (9)Rich Text Editor  (12)Road Map  (12)Scheduler  (54)Security  (5)SfDataGrid  (9)Silverlight  (21)Sneak Peek  (32)Solution Services  (4)Spreadsheet  (11)SQL  (15)Stock Chart  (1)Surface  (4)Tablets  (5)Theme  (12)Tips and Tricks  (112)UI  (406)Uncategorized  (68)Unix  (2)User interface  (68)Visual State Manager  (2)Visual Studio  (31)Visual Studio Code  (19)Web  (628)What's new  (341)Windows 8  (19)Windows App  (2)Windows Phone  (15)Windows Phone 7  (9)WinRT  (26)

Applying Chart Filters Using Essential XlsIO

Excel 2013 provides a rich set of charting capabilities such as chart recommendations, combo charts, and chart polishing. With chart polishing, Microsoft has provided quick access to common operations like adding or removing various chart elements, chart styles, and chart filters.

Chart filters allow you to easily add or remove categories and series from a chart. Sometimes extraneous data is accidentally included in a chart; chart filters can be used to present only the relevant content.


Figure 1 – Chart filtering option in MS Excel 2013

In our Essential Studio 2012, Volume 4 release, we added a chart filter option in Essential XlsIO. This filter can be applied to chart categories and series by setting the IsFiltered property of the interfaces IChartCategory and IChartSerie.

The following code snippet illustrates how to apply chart filters using Essential XlsIO.

//The first worksheet object in the worksheet’s collection is accessed.
 IWorksheet worksheet = workbook.Worksheets[0];
 //Chart accessed from the worksheet.          
  IChart chart= worksheet.Charts[0];
 //Apply the category filter.
  string[] categorieNames = { "QUARTER 1", "QUARTER 3" };
  foreach (string categoryName in categorieNames)
     chart.Categories[categoryName].IsFiltered = true;

   //Apply the series filter.
   string[] serieNames = { "Saddle Bags", "Tires", "Rear Sprockets" };
   foreach (string serieName in serieNames)
    chart.Series[serieName].IsFiltered = true;

For a sample on using chart filters, please follow this link:

– XlsIO Team


Share this post:

Popular Now

Be the first to get updates

Subscribe RSS feed