How to Hide or Exclude Categories of a Variable

When creating a report, you may need to cut out some unnecessary data from the charts to create a filtered view for your clients. For example, some variables in your dataset may contain "Don't know" or similar categories which you don't want to show on a PowerPoint chart. Depending on whether you want to include the hidden category values in your calculations or completely count out, you can use the option Hide or Exclude.

Before showing how easily you can do it on PowerPoint charts, it’s important to understand the difference between Hide and Exclude.

• Hide:  Hides the selected category from the chart, keeping the hidden values included in the calculation.

Method

1. In Chart Maker, right-click on the variable in Column or Row > Hide
2. In the Hide dialog box, select categories > Apply

• Exclude: Excludes the selected category from the chart and counts out the value of the selected category.

Method

1. In Chart Maker, right-click on the variable in Column or Row > Exclude
2. In the Exclude dialog box, select categories > Apply