Excel graphing tutorials
- Dixon, M. R., Jackson, J. W., Small, S. L., Horner-King, M. J., Lik, N. M. K., Garcia, Y., & Rosales, R. (2009). Creating single-subject design graphs in Microsoft Excel 2007. Journal of Applied Behavior Analysis, 42(2), 277–293. https://doi.org/10.1901/jaba.2009.42-277 Task analyses for single-case graphs in Excel. The one-column-per-phase layout used in Excel Lesson 1 follows this tradition.
- Vanselow, N. R., & Bourret, J. C. (2012). Online interactive tutorials for creating graphs with Excel 2007 or 2010. Behavior Analysis in Practice, 5(1), 40–46. https://doi.org/10.1007/BF03391816 Interactive tutorials with built-in practice and feedback.
- Deochand, N., Costello, M. S., & Fuqua, R. W. (2015). Phase-change lines, scale breaks, and trend lines using Excel 2013. Journal of Applied Behavior Analysis, 48(2), 478–493. https://doi.org/10.1002/jaba.198 Phase-change lines, scale breaks, trend lines, and raising zero above the horizontal axis.
- Dubuque, E. M. (2015). Inserting phase change lines into Microsoft Excel graphs. Behavior Analysis in Practice, 8(2), 207–211. https://doi.org/10.1007/s40617-015-0078-8 Phase-change lines built into the chart rather than drawn on top (Excel Lesson 4).
- Deochand, N. (2017). Automating phase change lines and their labels using Microsoft Excel. Behavior Analysis in Practice, 10(3), 279–284. https://doi.org/10.1007/s40617-016-0169-1 Lines and labels that update with the data, as in the templates.
- Fuller, T. C., & Dubuque, E. M. (2019). Integrating phase change lines and labels into graphs in Microsoft Excel. Behavior Analysis in Practice, 12(1), 293–299. https://doi.org/10.1007/s40617-018-0248-6 Phase labels that are part of the chart (Excel Lesson 4, Part B).
- Chok, J. T. (2019). Creating functional analysis graphs using Microsoft Excel 2016 for PCs. Behavior Analysis in Practice, 12(1), 265–292. https://doi.org/10.1007/s40617-018-0258-4 Functional analysis formats, including multielement graphs (Excel Lesson 6).
- Watts, Z. B., & Stenhoff, D. M. (2021). Creating multiple-baseline graphs with phase change lines in Microsoft Excel for Windows and macOS. Behavior Analysis in Practice, 14(4), 996–1009. https://doi.org/10.1007/s40617-021-00552-0 Multiple baseline graphs on both platforms (Excel Lesson 5).
- Blair, B. J., & Mahoney, P. J. (2022). Creating single-subject research design graphs with Google applications. Behavior Analysis in Practice, 15(1), 295–311. https://doi.org/10.1007/s40617-021-00604-5 A free alternative using Google Sheets and Slides, the same pairing the Google Sheets lessons use to assemble a multiple baseline figure (Sheets Lesson 5).
Graph construction standards
- American Psychological Association. (2020). Publication manual of the American Psychological Association (7th ed.). https://doi.org/10.1037/0000165-000 Figure number, title, and note; sans serif fonts between 8 and 14 points (Excel Lesson 7).
- Kubina, R. M., Kostewicz, D. E., Brennan, K. M., & King, S. A. (2017). A critical review of line graphs in behavior analytic journals. Educational Psychology Review, 29(3), 583–598. https://doi.org/10.1007/s10648-015-9339-x Graph construction standards, including a vertical-to-horizontal axis ratio between 5:8 and 3:4 (Excel Lesson 2).
- Kubina, R. M., Kostewicz, D. E., King, S. A., Brennan, K. M., Wertalik, J., Rizzo, K., & Markelz, A. (2021). Standards of graph construction in special education research: A review of their use and relevance. Education and Treatment of Children, 44(4), 275–290. https://doi.org/10.1007/s43494-021-00053-3
- Dart, E. H., & Radley, K. C. (2017). The impact of ordinate scaling on the visual analysis of single-case data. Journal of School Psychology, 63, 105–118. https://doi.org/10.1016/j.jsp.2017.03.008 Shows that the scaling of the vertical axis changes how large an effect looks to visual analysts.
- Radley, K. C., Dart, E. H., & Wright, S. J. (2018). The effect of data points per x- to y-axis ratio on visual analysts' evaluation of single-case graphs. School Psychology Quarterly, 33(2), 314–322. https://doi.org/10.1037/spq0000243
- Dart, E. H., & Radley, K. C. (2018). Toward a standard assembly of linear graphs. School Psychology Quarterly, 33(3), 350–355. https://doi.org/10.1037/spq0000269
Research on teaching graphing
- Tyner, B. C., & Fienup, D. M. (2015). A comparison of video modeling, text-based instruction, and no instruction for creating multiple baseline graphs in Microsoft Excel. Journal of Applied Behavior Analysis, 48(3), 701–706. https://doi.org/10.1002/jaba.223
- Mitteer, D. R., Greer, B. D., Fisher, W. W., & Cohrs, V. L. (2018). Teaching behavior technicians to create publication-quality, single-case design graphs in GraphPad Prism 7. Journal of Applied Behavior Analysis, 51(4), 998–1010. https://doi.org/10.1002/jaba.483 Lists features of publication-quality graphs, including a zero point raised slightly above the horizontal axis (Excel Lesson 3), and scores graphs with an itemized checklist. The Prism guides build the same features in Prism 10.
- Berkman, S. J., Roscoe, E. M., & Bourret, J. C. (2019). Comparing self-directed methods for training staff to create graphs using GraphPad Prism. Journal of Applied Behavior Analysis, 52(1), 188–204. https://doi.org/10.1002/jaba.522 Compared enhanced written instructions with video instruction. The format of these lessons, written steps with pictures, is one of the formats it studied.
- Kranak, M. P., Shapiro, M. N., Sawyer, M. R., Deochand, N., & Neef, N. A. (2019). Using behavioral skills training to improve graduate students' graphing skills. Behavior Analysis: Research and Practice, 19(3), 247–260. https://doi.org/10.1037/bar0000131
- Lehardy, R. K., Luczynski, K. C., Hood, S. A., & McKeown, C. A. (2021). Remote teaching of publication-quality, single-case graphs in Microsoft Excel. Journal of Applied Behavior Analysis, 54(3), 1265–1280. https://doi.org/10.1002/jaba.805 Paired video instruction with a review checklist, the model for the self-review checklist.
- Kranak, M. P., & Mitteer, D. R. (2022). A concise review of recent advancements in the graphical training of behavior analysts. Journal of Applied Behavior Analysis, 55(4), 1349–1354. https://doi.org/10.1002/jaba.943
- Zonneveld, K. L. M., Cox, A. D., Asaro, M. M., Hranchuk, K. S., Alami, A., Kelly, L. D., & Frijters, J. C. (2024). Comparing instructor-led, video-model, and no-instruction control tutorials for creating single-subject graphs in Microsoft Excel: A systematic replication and extension. Journal of Applied Behavior Analysis, 57(2), 502–514. https://doi.org/10.1002/jaba.1053
- Mondati, A. D., Reeve, S. A., Vladescu, J. C., DeBar, R. M., & Thomas, R. R. (2025). Remote teaching of AB graphs in Microsoft Excel. Behavior Analysis in Practice, 18(1), 96–108. https://doi.org/10.1007/s40617-024-00943-z
Single-case designs and visual analysis
- Kratochwill, T. R., Hitchcock, J., Horner, R. H., Levin, J. R., Odom, S. L., Rindskopf, D. M., & Shadish, W. R. (2010). Single-case designs technical documentation (Version 1.0, pilot). What Works Clearinghouse. https://ies.ed.gov/ncee/wwc/Docs/ReferenceResources/wwc_scd.pdf The minimum standards on the design pages; three demonstrations of an effect and the strong, moderate, and no-evidence ratings (Visual analysis Lesson 2); and the six features of visual analysis (Visual analysis Lesson 1). Later WWC handbooks revised the rating process; see the current WWC handbooks.
- Kratochwill, T. R., Hitchcock, J. H., Horner, R. H., Levin, J. R., Odom, S. L., Rindskopf, D. M., & Shadish, W. R. (2013). Single-case intervention research design standards. Remedial and Special Education, 34(1), 26–38. https://doi.org/10.1177/0741932512452794
- What Works Clearinghouse. (2017). What Works Clearinghouse standards handbook (Version 4.0). U.S. Department of Education, Institute of Education Sciences. https://ies.ed.gov/ncee/wwc/Docs/referenceresources/wwc_standards_handbook_v4.pdf The multiple probe rules on the multiple baseline page (pp. A-5 to A-6).
- Horner, R. H., Carr, E. G., Halle, J., McGee, G., Odom, S., & Wolery, M. (2005). The use of single-subject research to identify evidence-based practice in special education. Exceptional Children, 71(2), 165–179. https://doi.org/10.1177/001440290507100203 At least three demonstrations of an effect at three different points in time (Visual analysis Lesson 2).
- Cooper, J. O., Heron, T. E., & Heward, W. L. (2020). Applied behavior analysis (3rd ed.). Pearson. Baseline logic: prediction, verification, and replication (Visual analysis Lesson 2).
- Lane, J. D., & Gast, D. L. (2014). Visual analysis in single case experimental design studies: Brief review and guidelines. Neuropsychological Rehabilitation, 24(3–4), 445–463. https://doi.org/10.1080/09602011.2013.815636 Step-by-step visual analysis, including stability envelopes (Visual analysis Lesson 4) and the 80% rule worked through in Visual analysis Lesson 6.
- Ledford, J. R., Lane, J. D., & Severini, K. E. (2018). Systematic use of visual analysis for assessing outcomes in single case design studies. Brain Impairment, 19(1), 4–17. https://doi.org/10.1017/BrImp.2017.16
- Fisher, W. W., Kelley, M. E., & Lomas, J. E. (2003). Visual aids and structured criteria for improving visual inspection and interpretation of single-case designs. Journal of Applied Behavior Analysis, 36(3), 387–406. https://doi.org/10.1901/jaba.2003.36-387 The conservative dual-criteria method and its table of points needed beyond both lines (p. 399; Visual analysis Lesson 4), and the lines calculated by hand (Visual analysis Lesson 5).
- Swoboda, C. M., Kratochwill, T. R., & Levin, J. R. (2010). Conservative dual-criterion method for single-case research: A guide for visual analysis of AB, ABAB, and multiple-baseline designs (WCER Working Paper No. 2010-13). Wisconsin Center for Education Research, University of Wisconsin–Madison. https://wcer.wisc.edu/wp-content/uploads/sites/348/2026/08/WCER_WorkingPaper_Swoboda-Kratochwill-Levin_2010.12.20.pdf Reprints Fisher et al.'s table of criteria (Table 1), and applies the dual-criteria method to each phase change of a reversal design and each tier of a multiple baseline design (Visual analysis Lesson 4; worked through in Visual analysis Lesson 5).
- Stewart, K. K., Carr, J. E., Brandt, C. W., & McHenry, M. M. (2007). An evaluation of the conservative dual-criterion method for teaching university students to visually inspect AB-design graphs. Journal of Applied Behavior Analysis, 40(4), 713–718. https://doi.org/10.1901/jaba.2007.713-718
- Lanovaz, M. J., & Hranchuk, K. (2021). Machine learning to analyze single-case graphs: A comparison to visual inspection. Journal of Applied Behavior Analysis, 54(4), 1541–1552. https://doi.org/10.1002/jaba.863 Includes evidence that agreement among visual analysts is imperfect (Visual analysis Lesson 2).
- Barlow, D. H., & Hayes, S. C. (1979). Alternating treatments design: One strategy for comparing the effects of two treatments in a single subject. Journal of Applied Behavior Analysis, 12(2), 199–210. https://doi.org/10.1901/jaba.1979.12-199
- Sindelar, P. T., Rosenberg, M. S., & Wilson, R. J. (1985). An adapted alternating treatments design for instructional research. Education and Treatment of Children, 8(1), 67–76. The adapted alternating treatments design.
- Hartmann, D. P., & Hall, R. V. (1976). The changing criterion design. Journal of Applied Behavior Analysis, 9(4), 527–532. https://doi.org/10.1901/jaba.1976.9-527 Varied subphase lengths and step sizes in a changing criterion design (Visual analysis Lesson 3, Part F).
- Horner, R. D., & Baer, D. M. (1978). Multiple-probe technique: A variation of the multiple baseline. Journal of Applied Behavior Analysis, 11(1), 189–196. https://doi.org/10.1901/jaba.1978.11-189
- Iwata, B. A., Dorsey, M. F., Slifer, K. J., Bauman, K. E., & Richman, G. S. (1994). Toward a functional analysis of self-injury. Journal of Applied Behavior Analysis, 27(2), 197–209. https://doi.org/10.1901/jaba.1994.27-197 (Reprinted from Analysis and Intervention in Developmental Disabilities, 2, 3–20, 1982) The conditions of a multielement functional analysis (Visual analysis Lesson 3, Part E).
- Hagopian, L. P., Fisher, W. W., Thompson, R. H., Owen-DeSchryver, J., Iwata, B. A., & Wacker, D. P. (1997). Toward the development of structured criteria for interpretation of functional analysis data. Journal of Applied Behavior Analysis, 30(2), 313–326. https://doi.org/10.1901/jaba.1997.30-313 Comparing each test condition with the control condition (Visual analysis Lesson 3, Part E).
Related tools
- Reed, D. D., & Azulay, R. L. (2011). A Microsoft Excel 2010 based tool for calculating interobserver agreement. Behavior Analysis in Practice, 4(2), 45–52. https://doi.org/10.1007/BF03391783
How to cite this site
Single-Case Design Graphs was created by Anthony Concepcion, PhD, BCBA-D. In APA style:
Concepcion, A. (2026). Single-case design graphs. USF.ac. https://www.usf.ac/ssd/
Reference details were taken from each article's DOI record on October 18, 2026. The WWC documents and the WCER working paper were checked against their published copies on October 19, 2026. Sindelar et al. (1985) has no DOI; its details were checked against its ERIC record (EJ331419) the same day. Where a tutorial on this site makes a choice that the literature debates, the lesson says so. One example is solid versus dashed phase-change lines in Excel Lesson 4.