Skip to main content
SpringerLink
Log in

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

  • Technical and Tutorials
  • Published:
Behavior Analysis in Practice Aims and scope Submit manuscript

Abstract

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®).

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Fig. 1
Fig. 2
Fig. 3

Similar content being viewed by others

References

  • Carr, J. E., & Burkholder, E. O. (1998). Creating single-subject design graphs with Microsoft Excel™. Journal of Applied Behavior Analysis, 31(2), 245–251.

    Article  PubMed Central  Google Scholar 

  • Deochand, N. (2017). Automating phase change lines and their labels using Microsoft Excel®. Behavior Analysis in Practice, Advance online publication, 10, 279–284. https://doi.org/10.1007/s40617-016-0169-1.

    Article  PubMed  PubMed Central  Google Scholar 

  • 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.

    Article  PubMed  PubMed Central  Google Scholar 

  • Dubuque, E. M. (2015). Inserting phase change lines into Microsoft Excel® graphs. Behavior Analysis in Practice, 8(2), 207–211.

    Article  PubMed  PubMed Central  Google Scholar 

  • Johnston, J. M., & Pennypacker, H. S. (1980). Strategies and tactics of behavioral research (Third ed.). Hillsdale: Lawrence Erlbaum.

  • Pritchard, J. (2009). A decade later: creating single-subject design graphs with Microsoft Excel 2007™. The Behavior Analyst Today, 9, 153–161.

    Article  Google Scholar 

  • Tufte, E. R. (1983). The visual display of quantitative information. Chesire: Graphics Press.

    Google Scholar 

  • 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.

    Article  PubMed  PubMed Central  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Psychology, University of Nevada, Reno, Mail Stop 296, 1664 N. Virginia Street, Reno, 89557, USA

    Timothy C. Fuller

  2. Department of Pediatrics, University of Louisville, Louisville, KY, USA

    Erick M. Dubuque

Authors
  1. Timothy C. Fuller
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Erick M. Dubuque
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Timothy C. Fuller.

Ethics declarations

Conflict of Interest

The authors declare that they have no conflict of interest.

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

Fuller, T.C., Dubuque, E.M. Integrating Phase Change Lines and Labels into Graphs in Microsoft Excel®. Behav Analysis Practice 12, 293–299 (2019). https://doi.org/10.1007/s40617-018-0248-6

Download citation

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s40617-018-0248-6

Keywords

Search

Navigation