/ Single-Case Design Graphs

Overview › Build it with AI › Lesson 3

Lesson 3 of 5About 10 minutes

Check and fix the result

Check every AI-built graph in two passes. First, ask the assistant to audit its own chart against a written list. Then look at the graph yourself. Fix what's wrong with a targeted follow-up prompt, or by hand when that's faster.

You will be able to

  • Run an audit prompt that has the assistant check its chart's actual settings, and have it fix every item that fails.
  • Compare the chart with the target graph and score it with the self-review checklist.
  • Decide whether to fix each mistake with a follow-up prompt or by hand.

Instructions for: The target picture, the checks, and the list of common mistakes below follow the graph you choose.

Pass 1: the audit prompt

Send this in the same conversation, right after the assistant finishes. Asking it to check the chart's actual settings works better than asking whether the graph "looks right." The same audit works for every graph type: items about parts your graph doesn't have, such as criterion lines, come back N/A.

Prompt · audit the chart
Audit the chart you just made by reading its actual settings, not from memory. For each item, answer PASS or FAIL with the value you found. Answer N/A for any part of the graph I did not ask for.

1. Chart type is X Y scatter with straight lines and markers.
2. Every phase or condition is a separate series, all using the Session column as X values.
3. No data path connects the last point of one phase to the first point of the next.
4. No chart title, no gridlines, no chart-area border. No legend, unless I asked for one; then it lists only the series I named, sits inside the plot area, and has no border.
5. Axis minimums, maximums, and major units match what I asked for. The vertical minimum is exactly one major unit below 0, its negative label is hidden, and the horizontal axis crosses at that minimum.
6. Both axes are solid black 0.75 pt lines with outside major tick marks.
7. All text is Arial, black, not bold (11 pt axis titles, 10 pt for all other text).
8. All data series are black 1 pt lines with black size-6 markers, in the marker shapes and fills I asked for.
9. If I asked for empty cells to be connected, each condition is one continuous path, and no path drops to zero at sessions when that condition was not run.
10. Phase-change lines are chart series (not shapes) at the halfway points, running from the vertical axis minimum to its maximum.
11. Criterion lines are dashed chart series (not shapes), each at its criterion and spanning only its own phase.
12. Phase labels are data labels taken from cells (part of the chart, not text boxes), centered over each phase, above the plot area: no label overlaps the plot area or the top of the vertical axis.
13. None of my original data cells were changed.

Then fix every FAIL and run the audit again.

Pass 2: look at it yourself

Put the target picture next to the assistant's chart and compare them. Then score it with the self-review checklist.

Target: reversal (ABAB) graph of percentage of intervals on task. Data are 25 to 35 percent in the first baseline, rise to 60 to 85 percent in the first intervention phase, return to 30 to 45 percent in the second baseline, and rise to 80 to 92 percent when the intervention is reintroduced. Solid phase-change lines fall between sessions 5 and 6, 10 and 11, and 15 and 16, and the labels Baseline, Intervention, Baseline, Intervention sit above the plot, centered over each phase. Zero floats above the horizontal axis.
Target. Tier 1 (Participant 1) only. Its labels sit on the top edge of the plot, as in Excel Lesson 4. If the audit lowers the top of the plot area to put them above it, that is fine. Compare phase by phase. Check that each phase-change line falls between the right two sessions, and each label sits over the right phase.
Target: multielement functional analysis graph with five black condition paths, each connected across the sessions where it was not run and marked with its own black-and-white marker, and a borderless legend listing Play, Attention, Demand, Tangible, and Alone.
Target. Compare condition by condition. Check that each condition keeps its own marker and that the legend names each one correctly.

Common mistakes and the follow-up prompt for each

What you seeSend thisOr fix by hand
Phases or conditions joined by one continuous line"Each phase or condition must be a separate series using its own column, with column A as X values. Rebuild the series that way."Excel Lesson 1
A line chart with evenly spaced text categories"Change the chart type to X Y scatter with straight lines and markers, keeping column A as the X values for every series."Excel Lesson 2
Colors, gridlines, a chart title, or an unwanted legend"Make every series black (line and markers), and remove the chart title and all gridlines. Remove the legend too, unless I asked for one."Excel Lesson 3, Part A
A condition shows as scattered points, or its path drops to zero at sessions when it was not run"Set the chart's hidden and empty cells option to Connect data points with line. Do not put zeros in the empty cells."Excel Lesson 6
Phase-change lines are drawn shapes, or slightly off"Delete the drawn lines. Add each phase change as a two-point scatter series from a helper table, X at the halfway point, Y from the vertical axis minimum to its maximum."Excel Lesson 4, Part A
Phase-change lines stop short of the axes, or the axis range changed"Set the vertical axis minimum and maximum back to the values in my prompt, and make each phase-change line run from that minimum to that maximum."Excel Lesson 4
Criterion lines are solid, drawn as shapes, or run across the whole graph"Make each criterion line a two-point series from a helper table, from half a session before its phase's first session to half a session after its last, at that phase's criterion. Black 1 pt dashed, no markers."Excel Lesson 6
Phase labels missing, or typed in text boxes"Replace the labels with one helper series: no line or markers, data labels from the label-text cells, positioned above."Excel Lesson 4, Part B
Phase labels show a number (the Y value) instead of text"The data labels should show the text from the label cells, not the Y value. Turn off the Y value in the labels."Format Data Labels › Value From Cells
A phase label breaks onto two lines and hangs down into the plot"Keep each phase label on one line: turn off text wrapping in the data labels."Excel Lesson 4, Part B
Phase labels sit on the top edge of the plot or overlap the highest data"Lower the top edge of the plot area by about 0.2 in (14 pt), keeping its bottom and sides where they are, so every phase label sits above the plot area."Excel Lesson 4, Part B, step 7Excel Lesson 5, Part D, step 1
Fonts are Calibri or Aptos, or titles are bold"Set every text element in the chart to Arial, black, not bold: 11 pt axis titles and 10 pt for all other text."Excel Lesson 3, Part B
Zero sits on the horizontal axis, or tick labels read 5, 15, 25…"Set the vertical axis minimum to exactly one major unit below 0, hide negative labels with number format 0;;0, keep the labels whole numbers, and make the horizontal axis cross at the minimum."Excel Lesson 3, Part C
Chart is the wrong size"Resize the chart to 6.5 inches wide by 4.5 inches tall without changing font sizes."Excel Lesson 2, step 5
Your data were changed or movedClose without saving and reopen your copy. Then start over with "Do not change cells A1:E21A1:G19" at the top of the prompt.—

Know when to stop prompting. If two follow-ups haven't fixed something, fix it by hand. Every setting is covered in the Excel lessons, and a one-click change is often faster than a third prompt. AI is best at the repetitive parts: restructuring data, adding several series, and applying the same formatting to many elements.

Undo works differently with add-ins. Changes made by an add-in may not all reverse with Ctrl+Z / ⌘+Z. The copy you saved before prompting is your real undo.