Скачать или смотреть Creating Publication-Quality Multiple Baseline Graphs in Microsoft Excel

Click "Show More" to reveal download links for materials and video time stamps. If you have questions, please contact [email protected]


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:    • Remote Teaching of Publication-Quality, Si...  

To view the manuscript, click here: https://onlinelibrary.wiley.com/doi/1...


Download links for materials:

Multiple Baseline Graph: https://drive.google.com/uc?export=do...
Multielement Graph: https://drive.google.com/uc?export=do...
Reversal Graph: https://drive.google.com/uc?export=do...

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    • Alternate way to create clustered column bars  
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    • Alternate way to hide extra ink  
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