Behavior Analysis in Practice

, Volume 12, Issue 1, pp 293–299 | Cite as

Integrating Phase Change Lines and Labels into Graphs in Microsoft Excel®

  • Timothy C. FullerEmail author
  • Erick M. Dubuque
Technical and Tutorials


Creating phase change lines and their corresponding labels in Microsoft Excel® remains a difficulty for many behavior analysts who want these display features to be integrated into the graph itself. Previous methods designed to address this issue have had limited utility across the types of data sets commonly analyzed by behavior analysts. The purpose of this article is to provide a fully functional method for integrating phase change lines and labels into Microsoft Excel® line graphs. This method is a combination of previous recommendations and allows for easy integration of new data and exportation of graphical displays to other software programs (e.g., Microsoft Word® and PowerPoint®).


Microsoft Excel® Graphing Phase change lines Phase change labels 


Compliance with Ethical Standards

Conflict of Interest

The authors declare that they have no conflict of interest.


  1. Carr, J. E., & Burkholder, E. O. (1998). Creating single-subject design graphs with Microsoft Excel™. Journal of Applied Behavior Analysis, 31(2), 245–251.CrossRefGoogle Scholar
  2. Deochand, N. (2017). Automating phase change lines and their labels using Microsoft Excel®. Behavior Analysis in Practice, Advance online publication, 10, 279–284. Scholar
  3. 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(2), 277–293.CrossRefGoogle Scholar
  4. Dubuque, E. M. (2015). Inserting phase change lines into Microsoft Excel® graphs. Behavior Analysis in Practice, 8(2), 207–211.CrossRefGoogle Scholar
  5. Johnston, J. M., & Pennypacker, H. S. (1980). Strategies and tactics of behavioral research (Third ed.). Hillsdale: Lawrence Erlbaum.Google Scholar
  6. Pritchard, J. (2009). A decade later: creating single-subject design graphs with Microsoft Excel 2007™. The Behavior Analyst Today, 9, 153–161.CrossRefGoogle Scholar
  7. Tufte, E. R. (1983). The visual display of quantitative information. Chesire: Graphics Press.Google Scholar
  8. Vanselow, N. R., & Bourrett, J. C. (2012). Online interactive tutorials for creating graphs with Excel 2007 or 2010. Behavior Analysis in Practice, 5(1), 40–46.CrossRefGoogle Scholar

Copyright information

© Association for Behavior Analysis International 2018

Authors and Affiliations

  1. 1.Department of PsychologyUniversity of Nevada, RenoRenoUSA
  2. 2.Department of PediatricsUniversity of LouisvilleLouisvilleUSA

Personalised recommendations