/ Single-Case Design Graphs

Google Sheets lessons

Build it in Google Sheets

Seven lessons take you from the practice data to a figure ready for submission, free and in your web browser. They follow the same stages as the Excel lessons, so Lesson 4 is phase-change lines and labels in every tool. Choose the graph you want to make, and every lesson shows its data, cell ranges, and axis values, with numbered steps and a picture downloaded from Google Sheets at each stage.

Instructions for:

The finished reversal (ABAB) design graph in Google Sheets, with solid phase-change lines at sessions 5.5, 10.5, and 15.5 and the phase labels Baseline, Intervention, Baseline, and Intervention centered over each phase, above the data.
The reversal (ABAB) design graph you will build in Lessons 1–4, downloaded from Google Sheets.Tier 1 (Participant 1) of the multiple baseline graph, built in Lessons 1–4. Lesson 5 stacks it with the other tiers in Google Slides.

Lessons

Lessons 1 to 4 build the core skills on one reversal (ABAB) design graph, starting with the top tier (Participant 1) as a full-size chart. Lessons 5 and 6 apply the same skills to other designs, so you can skip them for this graph. Lesson 7 takes the figure into your manuscript or class paper.Lesson 5 copies that tier for each participant and stacks the tiers in Google Slides with a stepped phase-change line. Lesson 6 covers other designs, so you can skip it. Lesson 7 takes the figure into your manuscript or class paper.Lesson 5 covers multiple baseline graphs, so you can skip it. Lesson 6 recaps the settings your design needs, for when you graph your own data, and Lesson 7 takes the figure into your manuscript or class paper.

1

Set up your data

Session in column A and one column per phase, so the chart breaks the data path at every phase change.Session in column A and one column per condition, so each condition becomes its own data path.

About 5 minutes →
2

Create the chart

Insert a line chart that uses the session numbers in column A as a number line, and keep Sheets’ default size.

About 5 minutes →
3

Format for APA style

Black data paths joined across blank cells, with a point shape for each condition; no border, legend, or gridlines; a floating zero on the vertical axis, session 0 hidden, and axis titles, all in the chart editor.

About 15 minutes →
4

Phase-change lines and labels

Lines and labels built from helper rows under your data, so they never drift out of place.One phase-change line and labels built from helper rows, plus labels that name the two treatments beside their paths.Phase-change lines, labels, and dashed criterion lines, all built from helper rows under your data.A multielement graph has no phase-change lines; instead, add a legend that names each condition.

About 20 minutes →
5

Multiple baseline graphs

Not needed for your graph

Short tiers copied from one chart, stacked in Google Slides with tier names and a stepped phase-change line.

About 30 minutes →
6

Alternating treatments, multielement, and changing criterion

Not needed for your graph

The extra settings these designs need in Google Sheets: paths joined across blank cells, a point shape per condition, path labels or a legend, and dashed criterion lines.

About 15 minutes →
7

Download and place the figure

Download a vector file, then add the APA figure number, title, and note, and alt text.

About 10 minutes →

Before you start