This project came out of my master's thesis work. It still largely works a decade
later, but it is no longer maintained.
About
A free application for graphing time-series data in Microsoft Excel 2010 and later,
Formative Grapher is designed for consistency with APA Style.
Automated Features
Breaks in data paths
Condition labels & lines
Criterion lines
Date-session conversion
Figure captions
Floating y axes
1-click cumulative scales
1-click logarithmic scales
Scale breaks
Tier-stacking & doglegs
Tutorials
A beginner tutorial was published for the project and remains available on YouTube.
The tutorial is hosted on YouTube. Clicking play will load YouTube
and may set cookies on YouTube's domain. You can also watch it
directly on
YouTube
.
Download
Version 1.11 remains available as the last published release of the Excel template.
If you found Formative Grapher helpful for producing plots for publication, please
consider citing the journal article or software below.
Journal Article: Cole, D. M., & Witts, B. N. (2015).
Formative graphing with a Microsoft Excel 2013 template.Behavior Analysis: Research and Practice, 15, 171-186.
https://doi.org/10.1037/bar0000021
Video Tutorial: Cole, D. M. (observechange.org). (2017, February
20). Getting started with Formative Grapher [Video file]. Retrieved from
https://www.youtube.com/watch?v=yGsQ88-LT5o
Citations
Kranak, M. P., Shapiro, M. N., Sawyer, M. R., Deochand, N., & Neef, N. A.
(2019). Using behavioral skills training to improve graduate students' graphing
skills. Behavior Analysis: Research and Practice.
https://dx.doi.org/10.1037/bar0000131
Berkman, S. J., Roscoe, E. M., & Bourret, J. C. (2018). Comparing self-directed
methods for training staff to create graphs using Graphpad Prism.
Journal of Applied Behavior Analysis, 52(1), 188-204.
https://doi.org/10.1002/jaba.522
Mitteer, D. R., Greer, B. D., Fisher, W. W., & Cohrs, V. L. (2018). Teaching
behavior technicians to create publication-quality, single-case design graphs in
Graphpad Prism 7. Journal of Applied Behavior Analysis, 51(4), 998-1010.
https://doi.org/10.1002/jaba.483
Morris, C. A., Deochand, N., & Peterson, S. M. (2018). Using Microsoft Excel to
Build a Customized Partial-Interval Data Collection System.
Behavior Analysis in Practice, 11(4), 504-516.
https://doi.org/10.1007/s40617-018-0259-3
Runge, T. J., Bennyhoff, C. F., Ferchalk, M. R., & McCrea, A. E. (2017). The Role
of Measurement Interval in Rate of Improvement Calculation.
School Psychology Forum, 11(3), 77-90.
http://www.nasponline.org/...
Deochand, N. (2017). Automating phase change lines and their labels using Microsoft
Excel. Behavior Analysis in Practice, 10(3), 279-284.
https://doi.org/10.1007/s40617-016-0169-1
Tyner, B. C. (2016). The effects of descriptions and images of antecedent stimuli
and outcomes to correct responses in task analysis instruction. City University
of New York.
http://academicworks.cuny.edu/gc_etds/1631
Deochand, N., Costello, M. S., & Fuqua, R. W. (2016). Chart goals for behavior
analysis. Behavior Analysis: Research and Practice, 17(1), 10-13.
https://doi.org/10.1037/bar0000065
