Explore Chartrics with Sample Files

Sparkles

DataPlay is now Chartrics

Close
We’ve evolved to meet broader industry needs - with new AI-powered features, deeper Excel–PowerPoint integration, and support for Finance, Research, and Strategy teams.
Explore our rebranded website to learn more.
Home
>
Chart Maker
>
How to Filter Chart Data in PowerPoint?

How to Filter Chart Data in PowerPoint?

Filtering is a core part of data analysis. It helps you isolate specific segments of your dataset to better highlight trends, patterns, or insights – directly within your presentation.
 
For example, if you're analyzing responses on environmental attitudes, but want to focus only on a specific subgroup (e.g., a particular age range or region), you don’t need to switch to Excel or a BI tool. With Chartrics Chart Maker, you can apply filters right inside PowerPoint using an intuitive drag-and-drop interface.

How Filtering Works in Chart Maker?

To apply a filter:
  • Open Chart Maker in PowerPoint
  • Drag a variable onto the Filter panel
  • Use the available filtering tabs to customize how you want to narrow the data view
  • You can apply multiple filters simultaneously, and changes are reflected instantly in your chart.

Filtering Options

Chartrics offers several flexible filtering methods to help you focus on the exact data segments that matter most in your analysis.

General Filtering

Use this to include or exclude specific categories in your analysis.

Steps:

  • Drag a variable to the Filter panel in the General tab:
  • Choose how the filter should apply (On Values, On Total, Both, or None)
  • Select the categories you want to include
  • Click Apply

Conditional Filtering

Use this when you want to filter one variable based on the condition of another (e.g., only show regions where revenue > 1M).
Steps:
  • Drag a variable to the Filter panel
  • Go to the Condition tab
  • Under By Variable, choose a related variable
  • Define the condition (=, >, <, >=, etc.)
  • Set the value and click Apply

Top N Filtering

Use this to display only the top-performing values (e.g., top 5 products or regions).
Steps:
  • Drag a variable to the Filter panel
  • Go to the Top tab
  • Select the number of top entries to include
  • Choose the metric variable and relevant category
  • Click Apply
Thanks – your request is in! We’ll get back to you within one business day.
cross