Skip to main content
SpringerLink
Log in

Inserting Phase Change Lines into Microsoft Excel® Graphs

  • BAP Brief Practices
  • Published:
Behavior Analysis in Practice Aims and scope Submit manuscript

Abstract

Microsoft Excel® is a popular graphing tool used by behavior analysts to visually display data. However, this program is not always friendly to the graphing conventions used by behavior analysts. For example, adding phase change lines has typically been a cumbersome process involving the insertion of line objects that do not move when new data is added to a graph. The purpose of this article is to describe a novel way to add phase change lines that move when new data is added and when graphs are resized.

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

  • 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 Central  PubMed  Google Scholar 

  • 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 

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

    PubMed Central  PubMed  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Applied Behavior Analysis Program, Spalding University, Mansion East, Office #214, 845 South 3rd St., Louisville, KY, 40203, USA

    Erick M. Dubuque

Authors
  1. Erick M. Dubuque
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Erick M. Dubuque.

Additional information

1. Microsoft Excel® is a popular software program used by behavior analysts to graph and visually analyze data.

2. Current solutions to adding phase change lines within Microsoft Excel® have notable limitations.

3. The brief task analyses provided address these limitations and provide a novel way to add phase change lines using combined graphs, gradients, and transparency options.

4. Using this method, behavior analysts can quickly add phase change lines between two data points directly into their graphs saving time and effort when updating client data.

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

Dubuque, E.M. Inserting Phase Change Lines into Microsoft Excel® Graphs. Behav Analysis Practice 8, 207–211 (2015). https://doi.org/10.1007/s40617-015-0078-8

Download citation

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s40617-015-0078-8

Keywords

Search

Navigation