Creating Publication-Quality Multiple Baseline Graphs in Microsoft Excel
Channel: Prosocial Interactions Program
Date: 2021-02-02

Click "Show More" to reveal download links for materials and video time stamps. If you have questions, please contact robert.lehardy@icloud.com


This video tutorial is for practitioners, students, and teachers. It is an updated version of a video tutorial for a peer-reviewed manuscript that is located here: https://www.youtube.com/watch?v=ltmcsjRR2P4

To view the manuscript, click here: https://onlinelibrary.wiley.com/doi/10.1002/jaba.805


Download links for materials:

Multiple Baseline Graph: https://drive.google.com/uc?export=download&id=1KwJ7OuWFcPKVOd3s-usIthuQ-j7D8bQv
Multielement Graph: https://drive.google.com/uc?export=download&id=1gboC2HN4wa2uSUFC6DW22jwiRvwq4wQM
Reversal Graph: https://drive.google.com/uc?export=download&id=1ZO5gGu0uH-Y3V-TWnCe8IfrjOGpg3nrK 

Time stamps:

00:29 How to view the video model and use the alt-tab key
01:18 Hot keys to control the video model
01:51 Selecting panel 1 data and creating a scatterplot
02:31 Removing unneeded features
02:54 Moving a data series to the secondary y-axis
03:26 Modifying features of the x and y axes
05:46 Formatting data series markers and lines
08:34 Creating clustered column bars
           Alternate way to create clustered column bars https://youtu.be/Nu0u6lhgqGw
11:19 Removing data series lines to insert a phase change line
12:07 Floating the y-axis
13:56 Removing unneeded numbers from the x and y axes
15:45 Reselecting data on Windows computers 
18:30 Reselecting data on MacOS computers
19:52 Adding and formatting a phase change line
22:03 Removing x-axis numbers
22:19 Adding pinned text
28:04 Hiding extra ink on the y-axes
           Alternate way to hide extra ink https://youtu.be/gTRHo2wwLds
29:27 Removing unneeded data markers
29:57 Adding a staircase to connect phase lines between panels
31:53 Changing the panel height and width
32:53 Duplicating panels to create additional panels
33:42 Creating panel 2
37:58 Creating panel 3
40:16 Extending the phase change line to touch the x-axis
41:19 Moving all panels into a new spreadsheet
42:19 Removing panel borders and making panels transparent
42:59 Aligning panels
43:58 Adding a legend to panel 1
46:13 Adding x and y axes labels
48:12 Visually checking the graph for correspondence in features
49:16 Adding an arrow and label to a data marker