Smarter Solutions: IEE Chart Builder

Identify the Excel file with data

File input

Browse...

Select the chart type and options

Choose the IEE Chart Type

Enter either a text column to count values or numeric column with Category column entry with categories

Select Plot Column

Subgrouping column

Count in Moving Average

This value must be an integer 2 or greater

Category column

Choose the Pareto Function

Apply Ln to Std. Dev

Add Box-Plot Column (optional)

Method to determine capability?

Upper Specification

Lower Specification

Use Median or Mean in capability?

Stage Column Name

Optional: Choose the format of Stage Value

Enter Stage Values separated by commas. Entries must exist in Stage column.

Date Stage Values must use Format 'yyyy-mm-dd'

Column to use for I-chart X-axis (may not have repeat values)

Choose Type of Attribute

Data Distribution Choice

Box-Cox Lambda value

If any data values are <0, no tranform will be performed

Data Shift value

If any of the data is 0 or less, you must add a positive shift value This field cannot be left blank

Force Predictability?

Yes

Limiting the data used in the Charts

Enter first row of plotted data

The rows used for Omit function are after the Exclude rows are removed.

Enter rows numbers to Exclude from the Data, separate with commas.

Enter rows numbers to Omit from Limits, separate with commas.

Enter X Reference row numbers after accounting for the exclude and start adjustment

X axis Reference Line(s)

Y axis Reference Line(s)

Separate reference line repeat values with a comma

Enter Labeling Text

Enter Chart Title

Enter Chart Subtitle

Enter Chart Footnote

Metric Label to replace column name

Y axis Label

X axis Label