Creating a Bar Chart to Check Invalid Data

Create a bar chart to check invalid data.

To create a bar chart to check invalid data in the GENDER column:

Procedure

  1. On the toolbar, click Chart.
  2. In the Chart type area, click bar, and then configure the chart setting:
    1. From the X axis list, select GENDER.
    2. From the Y axis list, select Row Count.
    3. From the Group by list, select GENDER.
    4. Click Create chart.
      A bar chart is created.
    5. On the top of the chart, click stacked.

Result

A bar chart is created. The chart shows that the GENDER column has invalid values: (blank), 2, and X.