Build an individual-value plot

Example: adhesive strength

The example records 80 bonded joints, with 20 for each of four adhesive formulations. Strength is measured in MPa.

This is the same example used in Help. The CSV contains the observations to import.

1. Create the analysis

In the sidebar, open Plots and create an analysis. Name it, select New blank worksheet, then choose Create analysis.

2. Import the data

On Worksheet, choose Import. Select the downloaded CSV or paste its contents. Set the delimiter to Comma, use Decimal dot, and check First row contains column names. Preview the import, then choose Import into worksheet.

3. Assign the input columns

On Inputs, choose Individual-value plot in Chart type. In Data arrangement, choose One variable by group.

Open the column picker for Measurement and select lap_shear_strength_mpa. For Grouping column, select adhesive. Each point will represent one bonded joint, grouped by its formulation.

4. Set the chart options

In Statistics, choose Deterministic jitter for Point placement and Mean for Summary marker.

In Layout, choose First appearance for Order and Side by side for Comparison layout. Keep Blank categories or groups at Exclude and disclose.

Open Labels and enter See every adhesive-strength measurement in Chart title. Leave Horizontal axis label and Vertical axis label blank so the source labels are used.

Plots: Inputs with the example’s assignments and settings — Individual-value plot Inputs with the example’s column assignments, chart options and title. View full-size image (opens in a new tab)

5. Create chart

Choose Create chart, then open Results. Check Data used before comparing the chart with this guide. All stored worksheet rows participate; sorting or filtering the worksheet does not change the analytical sample.

6. Interpret results

Read the individual points
Each point is the strength of one bonded joint, in MPa. Small horizontal offsets separate overlapping points; they have no measurement meaning. The diamond shows the group’s mean.
Eighty individual joint strengths, with jittered points and a mean diamond for each formulation. View full-size chart (opens in a new tab)
Compare means and spread
Each formulation has 20 joints. Adhesive_C has the highest observed mean, 15.178 MPa, compared with 12.9655 MPa for Adhesive_A. Their individual strength ranges overlap, so the higher mean does not mean every C joint is stronger.
Keep the comparison limited
This picture does not test a formulation effect or show customer acceptance limits. Check how joints were prepared and assigned before attributing the difference to the adhesive.
Choose the next analysis
Use the interval chart to see uncertainty in the group means, then use ANOVA when the study design supports a formal comparison. Keep the individual measurements and practical strength requirement in view.

More details: read each result section

Complete result tables use six significant digits, as in Help.

Data used

Worksheet rows is 80; Eligible observations across series is 80; Excluded observations is 0. All source rows are used. Check these counts and keep the example’s column assignments when comparing runs. Worksheet sorting and filters do not change the analytical sample.

All stored rows are considered in original order. Worksheet sorting and filters do not change the analytical sample.

Data used · 1 row
Worksheet rows	Eligible observations across series	Excluded observations
80	80	0

Data summary

Series names the measurement or group. Valid and Missing give counts; Mean and Median describe the center. Sample SD describes spread. Minimum and Maximum are the observed ends; Q1 and Q3 enclose the middle half. These summaries describe the captured observations, not acceptance limits.

Data summary · 4 rows
Series	Valid	Mean	Sample SD	Minimum	Q1	Median	Q3	Maximum
Adhesive_B	20	13.2955	1.2016	10.66	12.6975	13.255	14.2325	15.34
Adhesive_C	20	15.178	1.12076	12.88	14.5675	15.215	15.745	17.07
Adhesive_D	20	14.2415	1.07341	11.5	13.875	14.47	15.085	15.79
Adhesive_A	20	12.9655	1.08188	10.27	12.4825	12.99	13.6925	15

Full chart observations

Series identifies the group; Worksheet row locates the source record. X retains source-row position and Y is the original measurement. X is not horizontal placement within a displayed group; the individual-value chart uses jitter to separate points. Check the original record before treating a point as an error.

Full chart observations · 80 rows
Series	Worksheet row	X	Y
Adhesive_B	1	1	12.56
Adhesive_B	5	5	12.74
Adhesive_B	10	10	10.66
Adhesive_B	14	14	11.83
Adhesive_B	16	16	13.16
Adhesive_B	19	19	14.01
Adhesive_B	20	20	14.3
Adhesive_B	21	21	14.85
Adhesive_B	23	23	12.71
Adhesive_B	24	24	14.33
Adhesive_B	25	25	11.28
Adhesive_B	28	28	13.47
Adhesive_B	40	40	13.67
Adhesive_B	52	52	12.9
Adhesive_B	54	54	15.34
Adhesive_B	62	62	14.21
Adhesive_B	69	69	12.66
Adhesive_B	71	71	13.08
Adhesive_B	73	73	13.35
Adhesive_B	75	75	14.8
Adhesive_C	2	2	14.88
Adhesive_C	4	4	14.66
Adhesive_C	7	7	12.88
Adhesive_C	11	11	16.54
Adhesive_C	13	13	15.73
Adhesive_C	17	17	15.71
Adhesive_C	22	22	13.61
Adhesive_C	27	27	16.96
Adhesive_C	29	29	14.29
Adhesive_C	32	32	15.22
Adhesive_C	34	34	15.21
Adhesive_C	38	38	15.79
Adhesive_C	39	39	16.02
Adhesive_C	42	42	14.26
Adhesive_C	47	47	14.98
Adhesive_C	64	64	15.58
Adhesive_C	65	65	15.13
Adhesive_C	67	67	13.34
Adhesive_C	70	70	15.7
Adhesive_C	78	78	17.07
Adhesive_D	3	3	14.36
Adhesive_D	6	6	15.21
Adhesive_D	12	12	12.59
Adhesive_D	26	26	14.72
Adhesive_D	35	35	12.58
Adhesive_D	41	41	15.34
Adhesive_D	48	48	13.98
Adhesive_D	49	49	14.59
Adhesive_D	53	53	15.19
Adhesive_D	55	55	13.47
Adhesive_D	56	56	13.9
Adhesive_D	57	57	13.89
Adhesive_D	58	58	15.05
Adhesive_D	60	60	11.5
Adhesive_D	61	61	14.58
Adhesive_D	63	63	13.83
Adhesive_D	66	66	15.25
Adhesive_D	72	72	14.71
Adhesive_D	74	74	15.79
Adhesive_D	76	76	14.3
Adhesive_A	8	8	15
Adhesive_A	9	9	13.67
Adhesive_A	15	15	13.9
Adhesive_A	18	18	11.23
Adhesive_A	30	30	11.71
Adhesive_A	31	31	12.89
Adhesive_A	33	33	13.37
Adhesive_A	36	36	13.09
Adhesive_A	37	37	12.28
Adhesive_A	43	43	10.27
Adhesive_A	44	44	12.2
Adhesive_A	45	45	13.76
Adhesive_A	46	46	12.55
Adhesive_A	50	50	13.63
Adhesive_A	51	51	12.85
Adhesive_A	59	59	12.73
Adhesive_A	68	68	12.87
Adhesive_A	77	77	13.79
Adhesive_A	79	79	13.33
Adhesive_A	80	80	14.19

7. Create a report

Keep the native chart and Data used, together with Data summary, Full chart observations. Record the column assignments and chart options. Include the study context and any checks of unusual observations. Keep the chart’s units and the limitations described in the walkthrough.

Choose Add to report from the completed run. Open Choose individual items and advanced options to select tables and charts, then choose Add to draft. Hidden items stay in the saved analysis.

Name the report and add the purpose of the study and your interpretation. Choose Save, review Preview, then use Export → Download HTML. The example below contains the full selected content, including results beyond one screen.

Complete native output for this Help example, including applicable tables, charts and run notes. Report numbers use the app’s displayed precision. Exported charts are static. On narrow screens, scroll wide charts and tables sideways.

Open full report Download HTML report

View example report