How to Filter a Chart Data in PowerPoint

On top of sorting, Data Filtering is another critical process in data analysis. It is helpful when you want to analyze and display specific information from a large dataset. For example, you researched the respondents' willingness to reduce gas emissions, but you want to analyze and show the data only for a particular sub-group of the sample base. To filter your data, you don't need to go to Excel or use other BI tools. Instead, you can use the Chartrics Chart Maker to easily filter your data by dragging the filter variable and dropping it onto the filter pane. You can apply as many filters to your data as you wish and instantly show the result on PowerPoint charts.

Filtering Options

- General

Method

1. In Chart Maker, drag a variable onto the Filter field by which you want to filter your crosstab
2. In the Filter dialog box > select one of the options you want the filter to apply on (on Values, on Total, on Both or None) > under Values, select the categories to include in the view > Apply

- Condition

Use this tab to filter the selected filter variable by another variable with a specific condition.

Method

1. In Chart Maker, drag a variable onto the Filter pane by which you want to filter your crosstab
2. Go to Condition tab > under By Variable, select a Variable > select a Category > select the Condition (<,>, =, >=, <=, <>,) > set the Value > Apply

- Top

Use this tab to limit the result of the filter variable showing only the top N of the values.

Method

1. In Chart Maker, drag a variable onto the Filter pane by which you want to filter your crosstab
2. Go to Top tab > under By Variable, select Top > Value > Variable > Category > Apply