/ Single-Case Design Graphs

Overview › Build it with AI › Lesson 2

Lesson 2 of 5About 10 minutes

Your first graph from one prompt

A short request such as "graph this data" gets you Excel's default chart: colored, gridded, and with phases joined. The prompt below spells out every rule from the Excel lessons, so the assistant builds the graph the way a journal expects.

You will be able to

  • Edit and send a detailed prompt that has Claude or ChatGPT build an APA-style reversal (ABAB) design graph (tier 1 only) in Excel.
  • Read each change the assistant asks to make, and decline any that would overwrite your data.
  • Compare the assistant's chart with the target graph and list what differs.

Instructions for: The prompt and the target picture below follow the graph you choose.

Before you prompt

  1. Lay out the data with one column per phase or condition. Use the layout from Excel Lesson 1: Session in column A, then one column per phase or condition. You can use the practice data (practice-reversal-data.xlsx), which has the column headers Baseline 1, Intervention 1, Baseline 2, and Intervention 2 in cells B1:E1, which has three participants with two columns each: P1 Baseline and P1 Intervention in columns B and C, then Participant 2 and Participant 3 in columns D to G. This lesson graphs Participant 1 only. If your data are in one long column, run the restructure prompt first.
  2. Save a copy of the workbook. Make sure it holds de-identified data only (why).
  3. Open the assistant pane. Then click into the worksheet that has the data.

The prompt

Copy the prompt, paste it into the assistant, and edit the bracketed, underlined parts to match your data before you send it. The brackets only mark what to edit; they are not copied with the prompt. The prompt changes when you pick a different graph type at the top of the page.

Tier 1 only. For a multiple baseline design, this prompt builds the first tier (Participant 1) as one full-size chart, the same practice graph you build by hand in Excel Lessons 1 to 4. To build the whole three-tier figure with its stepped connector, use the prompts in Lesson 4: Multiple baseline graphs with AI.

No phase-change lines. In a multielement functional analysis the conditions alternate within a single phase, so this prompt asks for a legend instead of phase-change lines and phase labels.

Prompt · reversal (ABAB) graphAB graphmultiple baseline, tier 1alternating treatments graphmultielement FA graphchanging criterion graph
Make a publication-ready, APA-style single-case design graph from the data on this sheet.

THE DATA
- Column A (Session) holds session numbers. Each other column is one phase: Baseline 1, Intervention 1, Baseline 2, Intervention 2. A session's value appears only in its phase's column; the other cells in that row are empty.
- Do not change, move, or delete any of my data cells.

THE CHART
1. Insert a native Excel X Y (scatter) chart with straight lines and markers. Do not use a line chart. Add one series per phase column, using column A as the X values for every series, so the data path breaks at each phase change.
2. Size: 6.5 inches wide by 4.5 inches tall (468 x 324 points). Place it below the data, starting in column A, so the helper tables beside the data stay visible.
3. Delete the chart title and the legend. Turn off all gridlines. No border on the chart area. No fill or border on the plot area.
4. Vertical axis: minimum -10 (exactly one major unit below 0, so zero floats above the horizontal axis), maximum 100, major unit 10, number format 0;;0 so the negative label is hidden, and the horizontal axis crosses at the minimum. Title "Percentage of Intervals On Task". Horizontal axis: minimum 0, maximum 22 (the first multiple of the major unit after the last session), major unit 2, number format 0;; so the 0 label is hidden, title "Session".
5. Both axes: solid black line 0.75 pt, major tick marks outside, no minor tick marks.
6. All chart text Arial, black, not bold. Tick labels 10 pt, axis titles 11 pt.
7. Every phase series: solid black line 1 pt; circle markers, size 6, black fill, black border.

PHASE-CHANGE LINES
8. In empty columns to the right of my data, make a small table headed "Phase lines". For each phase change, add two rows: X = halfway between the last session of one phase and the first session of the next (use a formula), with Y = the vertical axis minimum in the first row and Y = the vertical axis maximum in the second.
9. Add each phase change to the chart as its own two-point series from that table: solid black line 1 pt, no markers. Do not draw them as shapes.

PHASE LABELS
10. Make a second small table with one row per phase: label text (Baseline, Intervention, Baseline, Intervention), X = the middle session of that phase (use a formula), Y = the vertical axis maximum.
11. Add it as one series with no line and no markers. Show data labels whose text comes from the label-text cells instead of the Y values, positioned above the points, Arial 10 pt black. Then lower the plot area's top edge by about 0.2 in (14 pt), keeping its bottom, left, and right edges where they are, so every label sits above the plot area, outside it.

WHEN YOU ARE DONE
12. List every cell range you added, and tell me about any setting you could not apply exactly as written.
Make a publication-ready, APA-style AB design graph from the data on this sheet.

THE DATA
- Column A (Session) holds session numbers. Each other column is one phase: Baseline, Intervention. A session's value appears only in its phase's column; the other cell in that row is empty.
- Do not change, move, or delete any of my data cells.

THE CHART
1. Insert a native Excel X Y (scatter) chart with straight lines and markers. Do not use a line chart. Add one series per phase column, using column A as the X values for both series, so the data path breaks at the phase change.
2. Size: 6.5 inches wide by 4.5 inches tall (468 x 324 points). Place it below the data, starting in column A, so the helper tables beside the data stay visible.
3. Delete the chart title and the legend. Turn off all gridlines. No border on the chart area. No fill or border on the plot area.
4. Vertical axis: minimum -10 (exactly one major unit below 0, so zero floats above the horizontal axis), maximum 100, major unit 10, number format 0;;0 so the negative label is hidden, and the horizontal axis crosses at the minimum. Title "Percentage of Intervals With Problem Behavior". Horizontal axis: minimum 0, maximum 16 (the first multiple of the major unit after the last session), major unit 2, number format 0;; so the 0 label is hidden, title "Session".
5. Both axes: solid black line 0.75 pt, major tick marks outside, no minor tick marks.
6. All chart text Arial, black, not bold. Tick labels 10 pt, axis titles 11 pt.
7. Both phase series: solid black line 1 pt; circle markers, size 6, black fill, black border.

PHASE-CHANGE LINE
8. In empty columns to the right of my data, make a small table headed "Phase lines" with two rows: X = halfway between the last Baseline session and the first Intervention session (use a formula), with Y = the vertical axis minimum in the first row and Y = the vertical axis maximum in the second.
9. Add the phase change to the chart as its own two-point series from that table: solid black line 1 pt, no markers. Do not draw it as a shape.

PHASE LABELS
10. Make a second small table with one row per phase: label text (Baseline, Intervention), X = the middle session of that phase (use a formula), Y = the vertical axis maximum.
11. Add it as one series with no line and no markers. Show data labels whose text comes from the label-text cells instead of the Y values, positioned above the points, Arial 10 pt black. Then lower the plot area's top edge by about 0.2 in (14 pt), keeping its bottom, left, and right edges where they are, so every label sits above the plot area, outside it.

WHEN YOU ARE DONE
12. List every cell range you added, and tell me about any setting you could not apply exactly as written.
Make an APA-style graph of the first tier of a multiple baseline design from the data on this sheet. Build only tier 1 (Participant 1) for now, as one full-size chart.

THE DATA
- Column A (Session) holds session numbers. Columns B and C hold Participant 1's two phases: column B = P1 Baseline, column C = P1 Intervention. A session's value appears only in its phase's column; the other cell in that row is empty.
- Columns D to G hold the other participants. Leave them out of this chart.
- Do not change, move, or delete any of my data cells.

THE CHART
1. Insert a native Excel X Y (scatter) chart with straight lines and markers. Do not use a line chart. Add two series, one per phase column (B and C only), using column A as the X values for both series, so the data path breaks at the phase change.
2. Size: 6.5 inches wide by 4.5 inches tall (468 x 324 points). Place it to the right of all my data, past column G.
3. Delete the chart title and the legend. Turn off all gridlines. No border on the chart area. No fill or border on the plot area.
4. Vertical axis: minimum -10 (exactly one major unit below 0, so zero floats above the horizontal axis), maximum 100, major unit 10, number format 0;;0 so the negative label is hidden, and the horizontal axis crosses at the minimum. Title "Percentage Correct". Horizontal axis: minimum 0, maximum 20 (the first multiple of the major unit after the last session of any participant, so later tiers can share this scale), major unit 2, number format 0;; so the 0 label is hidden, title "Session".
5. Both axes: solid black line 0.75 pt, major tick marks outside, no minor tick marks.
6. All chart text Arial, black, not bold. Tick labels 10 pt, axis titles 11 pt.
7. Both phase series: solid black line 1 pt; circle markers, size 6, black fill, black border.

PHASE-CHANGE LINE
8. In empty columns to the right of all my data (column I or later), make a small table headed "Phase lines" with two rows: X = halfway between Participant 1's last Baseline session and first Intervention session (use a formula), with Y = the vertical axis minimum in the first row and Y = the vertical axis maximum in the second.
9. Add the phase change to the chart as its own two-point series from that table: solid black line 1 pt, no markers. Do not draw it as a shape.

PHASE LABELS
10. Make a second small table, also to the right of all my data, with one row per phase: label text (Baseline, Intervention), X = the middle session of that phase for Participant 1 (use a formula), Y = the vertical axis maximum.
11. Add it as one series with no line and no markers. Show data labels whose text comes from the label-text cells instead of the Y values, positioned above the points, Arial 10 pt black.

WHEN YOU ARE DONE
12. List every cell range you added, and tell me about any setting you could not apply exactly as written.
Make a publication-ready, APA-style alternating treatments graph from the data on this sheet.

THE DATA
- Column A (Session) holds session numbers. Each other column is one condition: column B = Baseline, column C = Treatment A, column D = Treatment B. Baseline comes first. After it, the treatments alternate from session to session, so each session's value appears only in the column of the condition run that session; the other cells in that row are empty.
- Do not change, move, or delete any of my data cells.

THE CHART
1. Insert a native Excel X Y (scatter) chart with straight lines and markers. Do not use a line chart. Add one series per condition column, using column A as the X values for every series.
2. Set the chart's hidden and empty cells option to "Connect data points with line" (Select Data > Hidden and Empty Cells), so each treatment is one continuous path across the sessions where it was not run. Do not put zeros in the empty cells.
3. Size: 6.5 inches wide by 4.5 inches tall (468 x 324 points). Place it below the data, starting in column A, so the helper tables beside the data stay visible.
4. Delete the chart title. Keep the legend for now; step 13 sets it up. Turn off all gridlines. No border on the chart area. No fill or border on the plot area.
5. Vertical axis: minimum -1 (exactly one major unit below 0, so zero floats above the horizontal axis), maximum 3, major unit 1, number format 0;;0 so the labels are whole numbers and the negative label is hidden, and the horizontal axis crosses at the minimum. Title "Responses per Minute". Horizontal axis: minimum 0, maximum 18 (the first multiple of the major unit after the last session), major unit 2, number format 0;; so the 0 label is hidden, title "Session".
6. Both axes: solid black line 0.75 pt, major tick marks outside, no minor tick marks.
7. All chart text Arial, black, not bold. Tick labels 10 pt, axis titles 11 pt, legend 10 pt.
8. Every condition series: solid black line 1 pt; markers size 6 with a black border, a different marker for each condition: Baseline filled black circles; Treatment A filled black squares; Treatment B open triangles (white fill). Never use color.

PHASE-CHANGE LINE
9. In empty columns to the right of my data, make a small table headed "Phase lines" with two rows: X = halfway between the last Baseline session and the first session of the alternating phase (the first session with a value in either treatment column; use a formula), with Y = the vertical axis minimum in the first row and Y = the vertical axis maximum in the second.
10. Add the phase change to the chart as its own two-point series from that table: solid black line 1 pt, no markers. Do not draw it as a shape.

PHASE LABELS
11. Make a second small table with one row per phase: label text (Baseline, Alternating Treatments), X = the middle session of that phase (use a formula), Y = the vertical axis maximum.
12. Add it as one series with no line and no markers. Show data labels whose text comes from the label-text cells instead of the Y values, positioned above the points, Arial 10 pt black. Then lower the plot area's top edge by about 0.2 in (14 pt), keeping its bottom, left, and right edges where they are, so every label sits above the plot area, outside it.

LEGEND
13. The legend lists only Treatment A and Treatment B. Delete the legend entries for Baseline, the phase-change line, and the phase labels. Place the legend inside the top-right of the plot area, where it covers no data points. No border, no fill.

WHEN YOU ARE DONE
14. List every cell range you added, and tell me about any setting you could not apply exactly as written.
Make a publication-ready, APA-style graph of a multielement functional analysis from the data on this sheet.

THE DATA
- Column A (Session) holds session numbers. Each other column is one condition: Play, Attention, Demand, Tangible, Alone (columns B to F). The conditions alternate from session to session, so each session's rate appears only in the column of the condition run that session; the other cells in that row are empty. A 0 in my data is a real session with no responding.
- Do not change, move, or delete any of my data cells.

THE CHART
1. Insert a native Excel X Y (scatter) chart with straight lines and markers. Do not use a line chart. Add one series per condition column, using column A as the X values for every series.
2. Set the chart's hidden and empty cells option to "Connect data points with line" (Select Data > Hidden and Empty Cells), so each condition is one continuous path across the sessions where it was not run. Do not put zeros in the empty cells.
3. Size: 6.5 inches wide by 4.5 inches tall (468 x 324 points). Place it below the data, starting in column A, so the helper tables beside the data stay visible.
4. Delete the chart title. Keep the legend for now; step 10 sets it up. Turn off all gridlines. No border on the chart area. No fill or border on the plot area.
5. Vertical axis: minimum -1 (exactly one major unit below 0, so zero floats above the horizontal axis), maximum 5, major unit 1, number format 0;;0 so the labels are whole numbers and the negative label is hidden, and the horizontal axis crosses at the minimum. Title "Responses per Minute". Horizontal axis: minimum 0, maximum 26 (the first multiple of the major unit after the last session), major unit 2, number format 0;; so the 0 label is hidden, title "Session".
6. Both axes: solid black line 0.75 pt, major tick marks outside, no minor tick marks.
7. All chart text Arial, black, not bold. Tick labels 10 pt, axis titles 11 pt, legend 10 pt.
8. Every condition series: solid black line 1 pt; markers size 6 with a black border, a distinct black-and-white marker for each condition: Play open circles (white fill); Attention filled black squares; Demand filled black triangles; Tangible filled black diamonds; Alone open squares (white fill). Never use color.
9. Do not add phase-change lines or phase labels. The conditions alternate within one phase.

LEGEND
10. The legend lists all five conditions in this order: Play, Attention, Demand, Tangible, Alone. Place it inside the top-right of the plot area where it covers no data points. No border, no fill.

WHEN YOU ARE DONE
11. List every cell range you added, and tell me about any setting you could not apply exactly as written.
Make a publication-ready, APA-style changing criterion graph from the data on this sheet.

THE DATA
- Column A (Session) holds session numbers. Each other column is one phase: Baseline, Phase 1, Phase 2, Phase 3, Phase 4, Phase 5 (columns B to G). A session's value appears only in its phase's column; the other cells in that row are empty.
- The criterion in effect during each phase is Phase 1 = 12, Phase 2 = 20, Phase 3 = 16, Phase 4 = 26, Phase 5 = 30 (minutes). Baseline has no criterion.
- Do not change, move, or delete any of my data cells.

THE CHART
1. Insert a native Excel X Y (scatter) chart with straight lines and markers. Do not use a line chart. Add one series per phase column, using column A as the X values for every series, so the data path breaks at each phase change.
2. Size: 6.5 inches wide by 4.5 inches tall (468 x 324 points). Place it below the data, starting in column A, so the helper tables beside the data stay visible.
3. Delete the chart title and the legend. Turn off all gridlines. No border on the chart area. No fill or border on the plot area.
4. Vertical axis: minimum -5 (exactly one major unit below 0, so zero floats above the horizontal axis), maximum 40, major unit 5, number format 0;;0 so the negative label is hidden, and the horizontal axis crosses at the minimum. Title "Minutes of Exercise". Horizontal axis: minimum 0, maximum 24 (the first multiple of the major unit after the last session), major unit 2, number format 0;; so the 0 label is hidden, title "Session".
5. Both axes: solid black line 0.75 pt, major tick marks outside, no minor tick marks.
6. All chart text Arial, black, not bold. Tick labels 10 pt, axis titles 11 pt.
7. Every phase series: solid black line 1 pt; circle markers, size 6, black fill, black border.

PHASE-CHANGE LINES
8. In empty columns to the right of my data, make a small table headed "Phase lines". For each phase change, add two rows: X = halfway between the last session of one phase and the first session of the next (use a formula), with Y = the vertical axis minimum in the first row and Y = the vertical axis maximum in the second.
9. Add each phase change to the chart as its own two-point series from that table: solid black line 1 pt, no markers. Do not draw them as shapes.

CRITERION LINES
10. Make another small table headed "Criterion lines". For each criterion phase, add two rows: X = half a session before the phase's first session in the first row and half a session after its last session in the second (use formulas), with Y = that phase's criterion in both rows.
11. Add each criterion line to the chart as its own two-point series from that table: black 1 pt dashed line (dash type Dash), no markers, so it looks different from the solid data paths and phase-change lines. Do not draw them as shapes.

PHASE LABELS
12. Make another small table with one row per phase: label text (Baseline, 12 min, 20 min, 16 min, 26 min, 30 min), X = the middle session of that phase (use a formula), Y = the vertical axis maximum.
13. Add it as one series with no line and no markers. Show data labels whose text comes from the label-text cells instead of the Y values, positioned above the points, Arial 10 pt black. Then lower the plot area's top edge by about 0.2 in (14 pt), keeping its bottom, left, and right edges where they are, so every label sits above the plot area, outside it.

WHEN YOU ARE DONE
14. List every cell range you added, and tell me about any setting you could not apply exactly as written.

Why so long? Each numbered line closes off a choice the assistant would otherwise make for you. Left alone, an assistant tends to pick Excel's defaults, or to draw phase lines as loose shapes. Writing the requirements as a numbered list also makes the result easy to check line by line in Lesson 3.

Send it and approve the changes

  1. Send the prompt. The assistant plans the work and then starts editing the workbook.
  2. Read each request before you approve it. ChatGPT asks for permission before it changes the workbook. Claude warns you before it overwrites data and asks before risky operations. If either one proposes to overwrite your data columns, decline and remind it: "Don't change cells A1:E21A1:G19."
  3. Read the summary. Note the helper ranges it lists, and any settings it says it could not apply. A multielement graph needs no helper tables, so the list of added ranges should be empty.

What you should get

Target result: reversal graph with black data paths, three solid phase-change lines, and the phase labels Baseline, Intervention, Baseline, Intervention above the plot, centered over each phase.
Target result. This is the graph built by hand in the Excel lessons to the same specifications. It shows tier 1 (Participant 1) only. The assistant's chart should match it closely. Small differences in label and legend position are normal.
Target result: 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 result. This is the graph built by hand in the Excel lessons to the same specifications. The assistant's chart should match it closely. Small differences in legend position are normal.

Before you move on, take a quick look at the chart. With the practice data:

AI output varies. The same prompt can give slightly different results from one day to the next, or between Claude and ChatGPT. Never submit an AI-built graph without checking it. Use the audit prompt and checklist in the next lesson. You are responsible for the figure, just as you would be if you had built it yourself.

Adapting the prompt