/ Single-Case Design Graphs

Overview › Build it in Excel › Lesson 6

Lesson 6 of 7About 15 minutes

Alternating treatments, multielement, and changing criterion

These designs use the same chart you already know. Each needs one or two extra settings: connecting points across blank cells, giving each condition its own marker and a legend, or adding dashed criterion lines.

You will be able to

  • Connect each condition’s points across blank cells in an alternating treatments or multielement graph, and give each condition a marker that can be told apart in black and white.
  • Add a borderless legend inside the plot that lists only the conditions a reader needs.
  • Add dashed criterion lines and criterion labels to a changing criterion graph.
Instructions for Excel in Microsoft 365

Your graph doesn't need this lesson. Lesson 6 is for alternating treatments, multielement (functional analysis), and changing criterion graphs. The graph you chose, Reversal (ABAB), has none of these extra settings. Go on to Lesson 7: Export and place the figure. If you haven't yet, stack your tiers in Lesson 5: Multiple baseline graphs, then go on to Lesson 7: Export and place the figure. Building one of those graphs instead? Choose it in the Graph box above so every lesson shows its steps, or go straight to its section: alternating treatments, multielement, or changing criterion.

Lessons 3 and 4 already covered these steps for your graph. They walked you through each one with your practice data and pictures. This lesson collects the rules and checks that are specific to each design in one place, so you can check your work or build the next graph from your own data. Your section: Alternating treatments design. Your section: Multielement design (functional analysis). Your section: Changing criterion design.

Alternating treatments design

Alternating treatments graph: a baseline phase near 2 responses per minute, followed by an alternating treatments phase where Treatment A (filled squares) declines toward 0.2 and Treatment B (open triangles) stays near 1.8. A legend inside the plot names the two treatments.
Baseline, then two treatments alternated across sessions. Each condition is one continuous path with its own marker, and a legend names the treatments.

Practice data: practice-atd-data.xlsx, 16 sessions in A1:D17.

Give each condition its own column, just like a phase. During the alternating phase, each session's value goes in the column for the condition run that session. Each condition's column now has blank cells between its values.

ABCD
1SessionBaselineTreatment ATreatment B
2–51–42.1 … 2.3
651.2
761.9
872.0
980.8
1090.6
Treatment A and Treatment B take turns, so each column has gaps between its values. The practice file continues to session 16 in row 17.
  1. Build the chart as usual. Select A1:D17 and insert a scatter chart with straight lines and markers, as in Lesson 2. Format it as in Lesson 3, with rate settings on the vertical axis: Minimum -1, Maximum 3, Major 1, horizontal axis crossing at -1, and format code 0;;0, so the labels are whole numbers. The practice rates peak at 2.5, so a maximum of 3 leaves room for the legend. Set the horizontal axis from 0 to 18, the first multiple of 2 past session 16, with a major unit of 2.
  2. Connect each condition across its blank cells. By default Excel leaves a gap at every blank, so each treatment would show as scattered points. Open Chart Design›Select Data. WindowsClick Hidden and Empty Cells at the bottom-left and choose Connect data points with line. Click OK twice. MacIn the Hidden and Empty Cells area at the bottom, set Show empty cells as to Connect data points with line. Click OK. The setting applies to every series in the chart. The baseline path still stops at the phase change, because its column has no later values to connect to.
  3. Give each condition a different marker. Click a condition's path, then open Format Data Series › Fill & Line › Marker. Under Marker Options, choose Built-in, a type, and size 6. The practice graph uses filled circles for Baseline, filled squares for Treatment A, and open triangles for Treatment B. For a filled marker, set Fill to Solid fill, black. For an open (hollow) marker, set Fill to Solid fill, white. Either way, set Border to Solid line, black, and keep every line black.
Gaps (Excel's default)
The alternating treatments chart before connecting: the baseline is one path, but Treatment A and Treatment B break into short colored segments and single points.
Before: each treatment breaks wherever its column has a blank cell.
Connected
The same chart after connecting across blank cells: Treatment A is one continuous black path of filled squares and Treatment B one continuous black path of open triangles. Baseline uses filled circles.
After steps 2 and 3: one continuous black path per condition, each with its own marker.

A path dips to zero between points? Excel connects only across cells that are truly empty. A cell that holds a space, text, or a formula that returns "" is plotted as 0. Select the cell and press Delete to empty it.

  1. Add the phase-change line and labels. Follow Lesson 4 exactly. The practice data change phase once, after session 4. The line table goes in F1:G3: Line X 4.5 in F2:F3, and Line Y -1 and 3 in G2:G3. Add it as one series named Phase change, with X values F2:F3 and Y values G2:G3. The label table goes in I1:K3: Baseline at Label X 2.5 and Alternating Treatments at 10.5, both with Label Y 3. Add it as a series named Phase labels, with X values J2:J3, Y values K2:K3, and Value From Cells I2:I3. Then turn off text wrapping for the labels, as Lesson 4 does: in Format Data Labels › Size & Properties › Alignment, uncheck Wrap text in shape. Otherwise Excel breaks Alternating Treatments onto two lines, and the second line hangs down into the plot. Then lower the top of the plot area about 0.2 in so both labels sit above it, and drag its right edge left about 0.1 in so it stays at least five-eighths as tall as it is wide (Lesson 4, Part B, step 7). Don’t lower the top much farther: a quarter inch leaves this plot area too flat.
  2. Add the legend last. Any series you add after the legend gets its own legend entry, so finish the lines and labels first. WindowsClick the chart, click + (Chart Elements), and check Legend. MacChoose Chart Design›Add Chart Element›Legend›Right. Double-click the legend to open Format Legend. Under Legend Options, uncheck Show the legend without overlapping the chart, so the plot area does not shrink to make room for it. Under Fill & Line › Border, choose No line. Drag the legend by its edge to an empty spot inside the plot area, such as the upper right, where it covers no data.
  3. Keep only the treatments in the legend. The legend lists every series, including Baseline, Phase change, and Phase labels. To remove one, click the legend once, click that entry once more so only it is selected, and press Delete. The series stays on the graph. The practice legend lists only Treatment A and Treatment B. Set the legend text to Arial 10 pt, black, like the other labels. Instead of a legend, you can also label each treatment's path directly with a text box near its last point.

Check your alternating treatments graph

Then read the graph. Do the two treatment paths separate clearly, with little or no overlap, across the whole alternating phase? See what experimental control looks like in an alternating treatments design.

Multielement design (functional analysis)

Multielement functional analysis graph with five conditions and a legend in the upper right. Demand is highest, between 2.5 and 3.6 responses per minute; Attention is near 1; Tangible stays between 0.3 and 0.6; Alone and Play stay near 0.
Five rapidly alternating conditions with no phase changes. Each condition has a distinct marker, and a legend inside the plot names them.

Practice data: practice-fa-data.xlsx, 25 sessions in A1:F26.

  1. One column per condition. Put session numbers in column A and one condition in each of columns B to F: Play, Attention, Demand, Tangible, and Alone. Type each session's rate under the condition run that session, so every row has exactly one rate. Type 0 for a session with no responding. Leave a cell blank only when that condition was not run in that session.
ABCDEF
1SessionPlayAttentionDemandTangibleAlone
210
320.9
432.5
540.6
650.2
763.1
870.1
The first seven sessions. Session 1 had no responding in Play, so its cell holds 0, not a blank. The practice file continues to session 25 in row 26.
  1. Insert and format the chart. Select A1:F26, insert a scatter chart with straight lines and markers, and format it as in Lesson 3. On the vertical axis, set Minimum -1, Maximum 5, Major 1, horizontal axis crossing at -1, and format code 0;;0, so the labels are whole numbers. The practice rates peak at 3.6. A maximum of 5 leaves room for the legend in the upper right. Set the horizontal axis from 0 to 26, one more than the last session, with a major unit of 2.
  2. Connect each condition across its blank cells. Turn on Connect data points with line exactly as in step 2 of the alternating treatments design. Every condition's column has blanks between its values, so without this setting all five conditions show as scattered points.
  3. Use five distinguishable markers. The practice graph uses open circles for Play, filled squares for Attention, filled triangles for Demand, filled diamonds for Tangible, and open squares for Alone. Set each marker as in step 3 of the alternating treatments design, at size 6. Open circles for the control (Play) condition is a common pattern. What matters most is that every marker reads clearly in black and white and stays the same across all your figures.
  4. Skip the phase-change lines and phase labels. All five conditions alternate within one phase, so there is nothing to separate or name. The legend identifies the conditions instead.
  5. Add a legend inside the plot area. Add it, remove its border, and drag it into an empty part of the plot as in step 5 of the alternating treatments design. Set its text to Arial 10 pt, black. Keep all five conditions in the legend; this graph has no helper series to remove. The legend lists the series in column order. The practice file puts the control condition, Play, first. To change the order, move the columns before you insert the chart, or select a series in Select Data and use the Move Up and Move Down arrows. Whatever order you choose, use it in every figure.

Zero rates stay visible. With the floating zero from Lesson 3, sessions with no responding sit on the 0 line, just above the horizontal axis, instead of on it. Keep markers at size 6 or larger. When two conditions share a shape, as Attention and Alone do here, make one filled and the other open so they can still be told apart in black and white.

Check your multielement graph

Then read the graph. Is responding in any test condition consistently higher than in the Play (control) condition, with little overlap? See Functional analysis: differentiated or not?

In the practice graph, Demand is clearly highest, at 2.5 to 3.6 responses per minute. Attention (0.8 to 1.1) and, at a lower level, Tangible (0.3 to 0.6) are also above Play (0 to 0.1) in all five cycles, with no overlap. Alone stays low (0.1 to 0.3) and overlaps Play at 0.1. Because each test condition is compared with Play, not just with the highest condition, this graph suggests escape plus attention, and possibly tangible: multiple control worth following up.

Changing criterion design

Changing criterion graph: baseline between 7 and 10 minutes, followed by five subphases of 3, 5, 3, 4, and 3 sessions with dashed criterion lines at 12, 20, 16, 26, and 30 minutes; the data stay within 1 minute of each criterion, including the step back down to 16.
A baseline, then subphases with a dashed horizontal line at each criterion level.

Practice data: practice-cc-data.xlsx, 23 sessions in A1:G24.

Why the subphases differ. The practice subphases last 3, 5, 3, 4, and 3 sessions, the criterion changes by different amounts (+8, −4, +10, and +4 minutes), and it steps back down from 20 to 16 minutes for a while. When behavior follows changes like these, time alone can’t explain them (see how the design shows control). The helper tables work the same for any subphase lengths and criteria: each criterion line spans exactly its own subphase.

  1. One column per subphase. Put Baseline, Phase 1, Phase 2, Phase 3, Phase 4, and Phase 5 in B1:G1, so the data path breaks at every criterion change. Select A1:G24, insert a scatter chart with straight lines and markers, and format it as in Lesson 3. On the vertical axis, set Minimum -5, Maximum 40, Major 5, horizontal axis crossing at -5, and format code 0;;0. The practice data peak at 31 minutes. A maximum of 40 keeps the highest point well below the top of the plot. Set the horizontal axis from 0 to 24, one more than the last session, with a major unit of 2.
  2. Add the phase-change lines. Follow Lesson 4. The practice data change phase after sessions 5, 8, 13, 16, and 20, so the line table in I1:J11 has five lines at 5.5, 8.5, 13.5, 16.5, and 20.5, each with Line Y -5 and 40. Add one series per line: I2:I3/J2:J3, I4:I5/J4:J5, I6:I7/J6:J7, I8:I9/J8:J9, and I10:I11/J10:J11. Keep these lines solid.
  3. Make a criterion-line table. Each criterion line is a two-point series. Its X values run from half a session before the subphase's first session to half a session after its last. Its Y values are the criterion twice. For a criterion of 12 during sessions 6–8: X = 5.5, 8.5 and Y = 12, 12. Type the table in P1:Q11.
PQ
1Criterion XCriterion Y
25.512← 12 min, sessions 6–8
38.512
48.520← 20 min, sessions 9–13
513.520
613.516← 16 min, sessions 14–16
716.516
816.526← 26 min, sessions 17–20
920.526
1020.530← 30 min, sessions 21–23
1123.530
Each pair of rows is one criterion line. Each line starts at its subphase's phase-change line and ends at the next one; the last ends half a session after session 23.
  1. Add each criterion line as a series. Use Chart Design›Select Data, then Add (Windows) or + (Mac), as you did for the phase-change lines. Name the first one Criterion, with X values P2:P3 and Y values Q2:Q3. Add four more the same way: P4:P5/Q4:Q5, P6:P7/Q6:Q7, P8:P9/Q8:Q9, and P10:P11/Q10:Q11.
  2. Make criterion lines dashed. Click a criterion line. In Format Data Series › Fill & Line › Line, choose Solid line, black, 1 pt, and a dashed Dash type such as Dash. Set Marker › Marker Options to None. Repeat for the other four. Dashing keeps the criterion visibly different from the data path and the solid phase-change lines.
The changing criterion chart with five solid phase-change lines at 5.5, 8.5, 13.5, 16.5, and 20.5 and five dashed criterion lines at 12, 20, 16, 26, and 30 minutes, each spanning its own subphase.
Solid phase-change lines and dashed criterion lines in place, before the labels.
  1. Label each subphase with its criterion. Use the phase-label method from Lesson 4. The label table goes in L1:N7: Baseline at Label X 3, then 12 min at 7, 20 min at 11, 16 min at 15, 26 min at 18.5, and 30 min at 22, all with Label Y 40. Use X values M2:M7, Y values N2:N7, and Value From Cells L2:L7. Then lower the top of the plot area about 0.2 in so the labels sit above it, as in Lesson 4, Part B, step 7. Don’t go much farther: a quarter inch leaves this plot area less than five-eighths as tall as it is wide.

Changed a criterion? Edit its two Criterion Y cells in column Q and its label in column L. The dashed line and the label move with the numbers.

Check your changing criterion graph

Then read the graph. Does responding shift to each new criterion soon after it changes and stay near it until the next change? See what experimental control looks like in a changing criterion design.

All three designs are available as ready-made templates, with the gap settings, markers, legends, criterion lines, and labels already in place.