A decade later: Creating single-subject design graphs with Microsoft Excel 2007™.

Abstract

In 1998 James Carr and Eric Burkholder authored a tutorial teaching the behavior analyst to graph single subject designs in Microsoft Excel 97. This tutorial has continued to be utilized across the release of four new versions. The release of Office 2007, however, requires that this tutorial be updated. The new user interface and the introduction of the "ribbon" require new instructions and introduce some new techniques. This article attempts to update the original introduction to Excel and incorporates some newer features as well.

Teaching behavior technicians to create publication‐quality, single‐case design graphs in graphpad prism 7

“…As noted by Deochand et al (2017), there may be a need for a more comprehensive list of graphing conventions. For the current investigation, we consulted a variety of scholarly and authoritative sources in our attempt to define the desirable features of publication-quality, single-case design graphs, including (a) books or chapters on graphing and visual interpretation (Bourret & Pietras, 2012; Cleveland, 1994; Tufte, 2001), and (b) technical and research articles on creating single-case design graphs using computer software programs (Barton & Reichow, 2012; Carr & Burkholder, 1998; Cole & Witts, 2015; Deochand, Costello, & Fuqua, 2015, 2017; Dixon et al, 2009; Dubuque, 2015; Grehan & Moran, 2005; Hillman & Miller, 2004; Lo & Konrad, 2007; Lo & Starling, 2009; Moran & Hirschbine, 2002; Pritchard, 2008; Tyner & Fienup, 2015; Vanselow & Bourret, 2012). We tabulated each recommended feature and the number of sources that recommended it.…”

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

“…Over the years, a few solutions have been developed to address these issues. The earliest solution to phase change lines and labels involved the use of drawing tools and text boxes (Carr & Burkholder, 1998;Dixon et al, 2009;Pritchard, 2009). However, this solution has been limited as these objects are external to the graph and therefore do not readjust their position and size when new data is added or the height and width of the graph is updated.…”

“…There are several tutorials designed to walk behavior analyst through the steps of creating a traditional line graph (Dixon et al, 2009;Pritchard, 2009;Vanselow & Bourrett, 2012;Dubuque, 2015). However, to date, there has not been an available task analysis for creating integrated phase change lines and labels in Excel® line graphs that is functional across numerical and non-numerical x-axis data.…”

Inserting Phase Change Lines into Microsoft Excel® Graphs

“…where necessary. Readers are encouraged to review the multitude of excellent comprehensive graphing tutorials available if they are unfamiliar with how to carry out these steps (see Dixon et al 2009;Pritchard 2009;Vanselow and Bourrett 2012). This solution for adding phase change lines is beneficial for several reasons.…”

“…Phase change lines are not intuitive to the software, which means that other workarounds need to be used to add these elements to graphs. The most common workaround described in the literature involves inserting line objects on top of graphs (Dixon et al 2009;Pritchard 2009). Unfortunately, line objects can be cumbersome to align within a graph and, more importantly, do not move when new data is added or when the graph is resized.…”