Excel lessons
Build it in Excel
Seven lessons take you from a blank worksheet to a figure ready for submission. Choose the graph you want to make, and every lesson shows its data, cell ranges, and axis values, with Windows and Mac instructions, numbered steps, and a picture exported from Excel at each stage.
Instructions for:
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 joins the tiers 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.
Set up your data
One column per phase, so Excel breaks the data path at every phase change.One column per condition, so each condition becomes its own data path.
About 5 minutes → 2Create the graph
Insert a scatter chart with straight lines and markers, and set its final size.
About 5 minutes → 3Format for APA style
Remove clutter; set axes, fonts, black data paths (connected across blank cells, with a distinct marker for each condition), and axis titles.
About 15 minutes → 4Phase-change lines and labels
Lines and labels built from data, so they never drift out of place.One phase-change line and labels built from data, plus a legend for the two treatments.Phase-change lines, labels, and dashed criterion lines, all built from data so they never drift out of place.A multielement graph has no phase-change lines; instead, add a legend that names each condition.
About 15 minutes → 5Multiple baseline graphs
Not needed for your graphAligned tiers, a shared axis title, and the stepped phase-change line.
About 25 minutes → 6Alternating treatments, multielement, and changing criterion
Not needed for your graphThe extra settings these designs need: paths connected across blank cells, distinct markers and a legend, and dashed criterion lines.
About 15 minutes → 7Export and place the figure
Vector export, APA figure number, title, and note, and alt text.
About 10 minutes →Before you start
- Graph type: choose your graph in the Graph box at the top of this page or in the bar at the top of any lesson. Every lesson then shows that graph’s data, cell ranges, axis values, and pictures. Keep the same choice from Lesson 1 to Lesson 7 so your worksheet matches the steps. If you make no choice, the lessons show the reversal (ABAB) graph.
- For a class: if your teacher gave you an assignment link or code, start at Your graphing assignment. It gives you your own data and graph type, and ends with a report to hand in. Choose that same graph type in the lessons. Your data have their own values and number of sessions, so your cell ranges, axis limits, and phase-change positions and axis limits can differ from the ones the lessons show. Teachers can create an assignment with an answer key for every student. Working on your own? Check the figure from Lesson 7 against the self-review checklist, and use the Visual analysis lessons to interpret what your graph shows.
- Excel version: written for Excel in Microsoft 365 (Windows, and Mac version 16) as of October 2026. Excel 2021 and 2024 use the same menus. Excel on the web can make the same chart but has fewer formatting options.
- Windows or Mac: each lesson opens on your computer's system. Use the switch at the top of a lesson to see the other.
- Pictures: every graph picture was exported directly from Excel, and each graph type has its own set. Drawings of menus, panes, and dialogs are simplified, so your screen may differ slightly.
- Practice files: Practice data for your graph (.xlsx) downloads as practice-reversal-data.xlsx and holds the reversal (ABAB) design data the lessons use. Participant 1 (columns A:C) is for Lessons 1–4; Participants 2 and 3, in the same workbook, are for Lesson 5. To try Lesson 5 as well, use the multiple baseline data.