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

Area of Science:

• Behavior Analysis
• Data Visualization

Background:

• Graphical elements in behavior analysis, such as phase change lines, are often manually inserted, leading to inefficiencies.
• Existing methods for avoiding or inserting graphical elements lack user-friendly solutions for automating phase labels.
• Microsoft Excel® is widely used by behavior analysts, but graphing solutions are not always intuitive.

Purpose of the Study:

• To provide an automated and user-friendly method for inserting phase change lines and their corresponding labels in behavior analytic graphs.
• To offer updated techniques and templates to streamline the creation of graphical displays in behavior analysis.
• To reduce the repetitive and time-consuming nature of manual graph element insertion.

Main Methods:

• Development of an updated procedure for embedding phase change lines and labels within graphical displays.
• Creation of supplemental templates to facilitate the implementation of the proposed method.
• Utilizing Microsoft Excel® for the automation of graphical elements in behavior analytic research.

Main Results:

• The proposed method automates the insertion of phase change lines and labels, reducing manual effort.
• Graphical elements remain embedded to the graph, ensuring consistency when graphs are moved or updated.
• The technique offers substantial time-savings for researchers in the field.

Conclusions:

• The developed method provides an efficient and automated solution for a common graphing challenge in behavior analysis.
• The updated approach enhances the user-friendliness of creating behavior analytic graphs, particularly within Microsoft Excel®.
• This work contributes to optimizing data visualization practices in behavior analysis, saving valuable researcher time.