Creating Functional Analysis Graphs Using Microsoft Excel® 2016 for PCs

Chok (2019) wrote a how-to guide. It shows every click to build four kinds of FA graphs in Excel 2016.

You get ready-made sheets for reversal, latency, multielement, and trial-based designs.

The guide works. Users who follow the steps end up with publication-ready FA graphs.

No new data were collected; the paper is a tool, not an experiment.

Fuller et al. (2019) came out the same year and went one step further. Their macro auto-draws phase lines and labels, so you skip the hand-draw step that Chok still uses.

Deochand (2017) and Deochand et al. (2015) built earlier phase-line tricks. Chok folds those ideas into full FA templates, moving from single tricks to a complete workbook.

Lehardy et al. (2021) later tested the whole package online. After a 15-minute video based on Chok’s steps, students hit 94% graph accuracy, proving the guide works in real training.

If you run FAs but hate graph time, download Chok’s Excel file. Copy your data into the colored cells and the graph builds itself. Want even faster prep? Add Fuller’s auto-phase-line macro to the same workbook and cut another five minutes. Either way, you leave session with a chart ready for the treatment team or insurance report.