Example of creating and graphing count data for a bar chart

A quality engineer for an automotive supply company wants to decrease the number of car door panels that are rejected because of paint flaws. As part of the initial investigation, the engineer creates a bar chart to compare the counts of paint flaws. The data are in the wrong format for a bar chart, so the engineer must create a saved view of the table with the Prep Tool .


This example explains how to prepare data so you can create a bar chart. You can use the same steps for many other charts, including column charts, pie charts, funnel charts, and pyramid charts.

  1. Open the Prep Tool . This example uses the data set in the Minitab Data Set Library, Paint flaws data.

    You cannot import a Minitab worksheet (MTW) into Minitab Connect. To import the data, save it as a CSV, XLSX, or copy and paste it. For more information on how to import data, go to Common tasks using the Base Tool and select Import data to a new table from an Excel file.

  2. On the Fields tab, select Add a Field and select Flaws to add a second instance of the Flaws field.

    If you just imported your data, you may need to select Reset Config to display the table.

  3. Rename the second instance of Flaws to Counts.
  4. Select the View button next to the Counts field and select Count.
  5. Select Run , and then select Save .
  6. Under View, select New View. Under Name, enter Flaws Summary Data. Then select Save.
  7. Open the Visualize Tool . From the Current Config dropdown list, select Flaws Summary Data.
  8. From Type, select Bar. Under Metric, select Flaws. Under Dimension, select Count.
  9. Select Run .

Interpret the results

Peel is the most common paint flaw, and Smudge and Other are the least common paint flaws.