By Matt Harrington, BCBA · Behaviorist Book Club · Research-backed answers for behavior analysts
Excel remains dominant in ABA graphing for several practical reasons. It is nearly universally available, familiar to most practitioners, and highly customizable. Dedicated ABA graphing software offers convenience but often lacks the flexibility to handle all graph types, unusual data formats, or complex clinical designs. Excel integrates readily with practice management software exports, allowing data to flow from collection systems into graphing templates with minimal re-entry. For practitioners who invest in developing Excel proficiency, it provides research-grade graphing capability with complete control over formatting, which is especially valuable for clinical documentation and publication-quality graphs.
The most commonly reported time sinks are manual data re-entry, axis reformatting for each new graph, adding phase change lines, and applying consistent formatting. These can be addressed systematically: data re-entry is reduced by building Excel templates that accept data directly from collection system exports. Axis reformatting is eliminated by saving chart formatting in templates with pre-configured scales. Phase change lines can be built into templates using secondary data series or vertical line workarounds. Applying consistent formatting is streamlined by standardizing fonts, colors, and labels in a master template used for all clients.
The most frequently used graph types in ABA are: the line graph (displaying frequency, rate, duration, or percentage correct across sessions), the bar graph (comparing performance across conditions or phases), the cumulative record (especially in precision teaching contexts), and the scatterplot (for functional analysis data and patterns over time). Line graphs are the workhorse of most clinical documentation. Building Excel templates for each of these types, pre-formatted with labeled axes and phase change line capability, addresses the majority of routine graphing needs. Multi-panel graphs for displaying multiple behaviors from the same client on a single page are also valuable for progress report documentation.
Phase change lines in Excel line graphs can be added using a secondary vertical line series, where a data point is plotted at the same x-axis value for the lowest and highest y-axis values. This approach requires some initial setup but produces consistent, accurate phase change lines that update when new data are added. Condition labels are typically added using text boxes positioned above the phase change area. A cleaner approach uses a secondary axis or custom axis labels to position condition names. Building these elements into a template once means they are available for every subsequent graph without manual re-creation.
The most practically useful Excel formulas for ABA data summarization are: AVERAGE (for session and phase means), STDEV (for variability analysis), COUNTIF (for counting trials meeting a criterion), IF and nested IF (for conditional data categorization), IFERROR (to handle missing data without displaying error codes), and INDEX/MATCH (for pulling data across multiple sheets or tables). For practitioners who collect discrete trial data, a COUNTIF formula that automatically counts correct responses out of total trials and expresses the result as a percentage dramatically reduces manual calculation. These formulas are most effective when embedded in standardized data entry templates.
Graphing accuracy is protected by several practices: using formulas rather than manual calculations for summary statistics eliminates arithmetic errors; double-checking data entry against the original data sheet before finalizing graphs catches transcription errors; using locked axis scales across clients enables consistent visual comparison and prevents inadvertent rescaling that distorts visual interpretation. Peer review of graphs before they are included in reports or insurance submissions adds a second check. For high-stakes documentation such as functional analysis data or authorization renewals, a brief treatment integrity checklist for graph accuracy is a worthwhile quality control step.
When graphing is efficient, behavior analysts are more likely to graph data promptly and review it regularly, which enables faster detection of meaningful trends, plateaus, and behavioral changes. Conversely, when graphing is laborious, practitioners may delay review, rely on memory rather than visual inspection, or make programming decisions without current data. Visual inspection of graphed data — identifying level, trend, and variability within and across conditions — is a clinical skill that requires actually looking at the graph. Efficiency removes the friction that delays this essential clinical activity.
JABA and other behavior analytic journals apply specific graphing conventions that are also appropriate for high-quality clinical documentation. These include: clearly labeled x and y axes with units, condition labels above phase change lines, data points connected within but not across conditions, consistent symbols for different behaviors or participants on the same graph, and axis scales selected to display meaningful variability without distortion. Equal-interval axes are standard; logarithmic axes are used in precision teaching contexts. Learning these conventions through access to published JABA articles provides a direct model for clinical graphing quality.
Graphing provides rich opportunities for clinical teaching. Supervisors can ask supervisees to generate a graph from raw data and then conduct visual inspection analysis together, using the visual as a prompt for clinical reasoning. Comparing a supervisee's graph interpretation to the supervisor's interpretation builds the skill of reading behavioral data. Reviewing graphs from past programs — identifying what prompted programming changes and whether those changes were timely — develops clinical judgment. Supervisors can also assign the task of building a graphing template as a supervision activity, developing both technical skill and conceptual understanding of why specific graphing conventions matter.
The University of Cincinnati ABA program's inclusion of practical graphing efficiency in professional development reflects a recognition that clinical skill includes both conceptual competency and practical execution. Training programs that address only the theory of data-based decision making without developing the practical tools to implement it leave graduates underprepared for the realities of caseload management. This session's networking format — combining skill development with professional community building — models a pedagogical approach that values peer learning and applied practice alongside formal instruction. For practitioners considering advanced degree programs, this kind of practical skills integration is a meaningful indicator of program quality.
The ABA Clubhouse has 60+ on-demand CEUs including ethics, supervision, and clinical topics like this one. Plus a new live CEU every Wednesday.
Ready to go deeper? This course covers this topic with structured learning objectives and CEU credit.
Networking Session: Don't Spend All Your Time Graphing: Excel and Graphing Tips — James Hawkins · 1 BACB General CEUs · $0
Take This Course →1 BACB General CEUs · $0 · BehaviorLive
Research-backed educational guide with practice recommendations
Side-by-side comparison with clinical decision framework
All behavior-analytic intervention is individualized. The information on this page is for educational purposes and does not constitute clinical advice. Treatment decisions should be informed by the best available published research, individualized assessment, and obtained with the informed consent of the client or their legal guardian. Behavior analysts are responsible for practicing within the boundaries of their competence and adhering to the BACB Ethics Code for Behavior Analysts.