Online Interactive Tutorials for Creating Graphs With Excel 2007 or 2010

Many researchers have rallied against drawn in graphical elements and offered ways to avoid them, especially regarding the insertion of phase change lines (Deochand, Costello, & Fuqua, 2015;Dubuque, 2015;Vanselow & Bourret, 2012). However, few have offered a solution to automating the phase labels, which are often utilized in behavior analytic graphical displays (Deochand et al., 2015). Despite the fact that Microsoft Excel® is extensively utilized by behavior analysts, solutions to resolve issues in our graphing practices are not always apparent or user-friendly. Considering the insertion of phase change lines and their labels constitute a repetitious and laborious endeavor, any minimization in the steps to accomplish these graphical elements could offer substantial time-savings to the field. The purpose of this report is to provide an updated way (and templates in the supplemental materials) to add phase change lines with their respective labels, which stay embedded to the graph when they are moved or updated.

Section: Discussionmentioning

confidence: 99%

“…

…”

mentioning

confidence: 99%

Automating Phase Change Lines and Their Labels Using Microsoft Excel(R)

Deochand

2017

“…Given how frequently behavior analysts update their graphs and the likelihood that they are simultaneously maintaining several graphs for multiple clients, this minor annoyance can quickly escalate into a significant waste of clinical time. Vanselow and Bourrett (2012) recently advocated for an alternative method for adding phase change lines. The method that they described involves graphing data as scatterplots and plotting phase change lines as error bars.…”

mentioning

confidence: 99%

Inserting Phase Change Lines into Microsoft Excel® Graphs

Dubuque

2015

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.

“…Furthermore, tracking client progress utilizing graphs and charts with data across several relevant behavioral dimensions is also vitally important. Task analyses (e.g., Deochand et al 2015) and videos (e.g., Vanselow and Bourret 2012) on graphing behavioral data are useful tools for practitioners to keep current in their data management and presentation skills. In the case of creating graphical displays, these enhancements generally take the form of higher quality graphs and time savings in utilizing new methodology.…”

mentioning

confidence: 99%

“…The task analysis below instructs the user to alter the dates of a graph for an entire year of data (or more) from one cell in a spreadsheet without altering embedded (i.e., not drawn in) phase changes that are currently recommended for singlesubject graphs in Excel® (Deochand et al 2015;Vanselow and Bourret 2012). Although the initial labor in creating such a template may be time intensive for the reader, the cumulative time saving it could afford throughout a year of practice might serve as an impetus to invest in a relatively small initial response cost.…”

mentioning

confidence: 99%

Recording an Excel® Macro to Specify Date Ranges for Clinical Data

Deochand

Costello

Fuqua

2015

The individuals served by behavior analysts are often funded by Medicaid, insurance companies, or private pay. The first two options usually require progress notes detailing graphically and quantitatively the behavioral outcomes. These progress notes usually come in the form of a written account of milestones achieved or barriers faced, graphical displays of behavioral data, and summary tables. The graphical displays are monthly, quarterly, and annual reports for the individuals that they serve. Microsoft Excel® is one of the most accessible tools by which to accomplish this task; however, presenting the required date ranges can be a timeconsuming task. A task analysis is outlined to automate this process and reduce the time taken to accomplish indirect service hours to the clients served.