Live Chat Icon For mobile
Live Chat Icon
Popular Categories.NET  (143).NET Core  (23)Angular  (39)ASP.NET  (47)ASP.NET Core  (53)ASP.NET MVC  (83)Azure  (27)Blazor  (50)DocIO  (18)Essential JS 2  (65)Essential Studio  (159)Flutter  (53)JavaScript  (135)Microsoft  (96)PDF  (48)React  (29)Succinctly series  (118)Syncfusion  (402)TypeScript  (30)Uno Platform  (2)UWP  (4)Vue  (25)Webinar  (14)Windows Forms  (52)WPF  (92)Xamarin  (106)XlsIO  (20)Other CategoriesBarcode  (4)BI  (29)Bold BI  (3)Build conference  (6)Business intelligence  (53)Button  (4)C#  (100)Chart  (40)Cloud  (8)Company  (445)Dashboard  (4)Data Science  (3)Data Validation  (2)DataGrid  (31)Development  (235)Doc  (7)eBook  (89)Enterprise  (22)Entity Framework  (5)Essential Tools  (14)Excel  (14)Extensions  (7)File Manager  (3)Gantt  (6)Gauge  (4)Git  (3)Grid  (25)HTML  (8)Installer  (1)Knockout  (2)LINQPad  (1)Linux  (1)M-Commerce  (1)Metro Studio  (11)Mobile  (141)Mobile MVC  (9)OLAP server  (1)Orubase  (12)Partners  (20)PDF viewer  (15)Performance  (2)PHP  (1)PivotGrid  (4)Predictive Analytics  (6)Report Server  (3)Reporting  (10)Reporting / Back Office  (11)Rich Text Editor  (5)Road Map  (9)Scheduler  (15)SfDataGrid  (7)Silverlight  (21)Sneak Peek  (12)Solution Services  (2)Spreadsheet  (2)SQL  (4)Stock Chart  (1)Surface  (4)Tablets  (5)Theme  (9)Tips and Tricks  (18)UI  (65)Uncategorized  (68)Unix  (2)User interface  (49)Visual State Manager  (1)Visual Studio  (12)Visual Studio Code  (7)Web  (100)What's new  (62)Windows 8  (19)Windows App  (1)Windows Phone  (15)Windows Phone 7  (9)WinRT  (26)
Share on twitter
Share on facebook
Share on linkedin

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.

clip_image002

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: https://www.syncfusion.com/downloads/Support/DirectTrac/12345/XlsIO_ChartFilters-1423402098.zip

 

– XlsIO Team

Tags:

Share this post:

Share on twitter
Share on facebook
Share on linkedin

Leave a comment

Popular Now

Be the first to get updates

Subscribe RSS feed
Scroll To Top