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

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

Remote teaching of publication‐quality, single‐case graphs in Microsoft Excel

“…Automated features remain in position when the axes' ranges change as new data are added or the graph size is changed, which is advantageous when graphs are updated over time. Researchers have created written and pictorial tutorials to describe how to insert automated phase lines (Dubuque, 2015; Fuller & Dubuque, 2019), an automated method to hide the y‐axis line after floating the y‐axis without using opaque shapes (Deochand et al, 2015), and automated text labels (Deochand, 2017). However, researchers have not described methods to insert staircase lines as an automated feature, and no video tutorial exists to teach individuals to create publication‐quality graphs with automated features in Excel 2016 or later versions.…”

Creating Single-Subject Research Design Graphs with Google Applications

“…Unlike other graphing tutorials (Dubuque, 2015 ; Fuller & Dubuque, 2018 ), our tutorial does not provide instructions for incorporating automatically generated and updated phase change lines in Sheets. Given the intended audience of this introductory tutorial, we elected to not include this option; however, manually inserting and updating phase change lines in Slides is fairly simple and not prohibitively time-consuming.…”

Upaya Peningkatan Pengetahuan Dasar Komputasi Statistik Menggunakan Fitur Data Analysis

“…Sama halnya dengan SPSS diperuntuhkan dalam menganalisis data antara lain menghitung toksifitas LD50 (lethal dose) atau penyelidikan pola penipisan cortical pada pasien LPA (Afasia progresif logopenik) dengan menerapkan model GLM (General Linear Model) (Lei & Sun, 2018;Thanprasertsuk & Likitjaroen, 2021). Selain menggunakan software yang ditelah dijabarkan sebelumnya, Billo, (2007); Winston (2007); Bancroft & Bourret, (2008); Neyeloff et al, (2012); Chien et al, (2017); Divisi et al, (2017) ;Chok, (2019) ;Cook, (2019); Fuller & Dubuque, (2019), memaparkan terdapat fitur tertentu di microsoft excel yang difungsikan untuk menganalisis data dan memaparkan visualisasi grafik hasil penelitian. Fitur yang dimaksud berupa formulas berisikan tools antara lain logical, statistika di bagian more fungtion dan didukung oleh VBA/macro (Visual Basic for Application) untuk menuliskan scrib pemrograman.…”