Chart Suggestion

Proposes suitable chart types for the selected columns

How the Chart Suggestion tool works

The Chart Suggestion tool reads the analytical roles of your selected columns and proposes suitable chart types, ranked by fit. The logic is inspired by Tableau's "Show Me" and the Minitab Graph Builder.

The quickest entry point is the "Suggest Chart" button in the Worksheet toolbar. Select one or more columns first.

Input: column selection: Pick one or more columns in the Worksheet. From the combination of their roles (Continuous, Categorical, Ordinal, Date) we derive the most fitting visualization type.

Output: ranking: On the left you see the ranked suggestions with their score (0–100, higher is better). On the right we render a preview of the selected chart type. Click a suggestion to switch the preview.

Effect of sample size: Some charts only make sense above a minimum n. With n < 20, the histogram is hidden in favor of boxplot and individual-value-plot. A control chart needs at least 25 data points.

Open in module: Most previews carry an "Open in module" button above the chart. It spawns a new instance of the full module (histogram, boxplot, individual-value plot, run chart, probability plot, or XY plot) in the same phase area, with the selected columns already wired up — so you can carry on with annotations, reference lines, axis tuning, or export. For pure comparison charts (bar, Pareto, pie) and for the scatter matrix the button is hidden — there is no single dedicated module to forward to.

Scatter matrix (≥3 continuous columns): Selecting three or more continuous columns suggests a scatter matrix (SPLOM). The preview renders an n×n grid of small scatter plots for all column pairs; the diagonal shows the column name. With more than six columns only the first six are displayed — a performance and readability limit.

Control-chart preview: For the combination "date + continuous" the suggestion includes a control chart. The preview automatically computes an I-chart (Individuals) with the centerline at the mean, ±3σ limits (σ derived from the mean moving range, d2=1.128) and observations sorted by date. Switch to the full Control-chart module under "Control" for X̄/R, X̄/S, or Phase-I exclusions.

Examples

This module ships with the following example datasets — load any of them in the app with a single click.