Behavior Analysis in Practice

, Volume 12, Issue 1, pp 265–292 | Cite as

Creating Functional Analysis Graphs Using Microsoft Excel® 2016 for PCs

  • James T. ChokEmail author
Technical and Tutorials


Practitioners in the field of applied behavior analysis rely on graphing software to display the data they collect during assessments. However, the graphing process can be cumbersome and procedures change as new versions of software programs are released. The current tutorial provides step-by-step instructions for graphing functional analysis data using Microsoft Excel 2016 for PCs. Instructions for creating functional analysis data depicted in reversal, latency, mulitielment, and trial-based functional analysis are provided.


Graphing Functional analysis Excel 


Compliance with Ethical Standards

Conflict of Interest

This author declares that he has no conflict of interest.

Ethical Approval

This article does not contain any studies with human or animal participants performed by the author.


  1. Carr, J. E., & Burkholder, E. O. (1998). Creating single-subject design graphs with Microsoft Excel™. Journal of Applied Behavior Analysis, 31, 245–251.Google Scholar
  2. Deochand, N. (2017). Automating phase change lines and their labels using Microsoft Excel®. Behavior Analysis in Practice, 10, 279–284.Google Scholar
  3. 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, 478–493.Google Scholar
  4. Dixon, M. R., Jackson, J. W., Small, S. L., Horner-King, M. J., Mui Ker Lik, N., Garcia, Y., & Rosales, R. (2009). Creating single-subject design graphs in Microsoft Excel™ 2007. Journal of Applied Behavior Analysis, 42, 277–293.Google Scholar
  5. Dubuque, E. M. (2015). Inserting phase change lines into Microsoft Excel® graphs. Behavior Analysis in Practice, 8, 207–211.Google Scholar
  6. 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.Google Scholar

Copyright information

© Association for Behavior Analysis International 2018

Authors and Affiliations

  1. 1.Melmark PennsylvaniaBerwynUSA

Personalised recommendations