This comparison draws in part from “Networking Session: Don't Spend All Your Time Graphing: Excel and Graphing Tips” by James Hawkins (BehaviorLive), and extends it with peer-reviewed research from our library of 27,900+ ABA research articles. The decision framework, BACB ethics code references, and cross-links below are synthesized by Behaviorist Book Club.
View the original presentation →The choice between building graphs manually for each client and developing reusable, pre-formatted templates represents one of the clearest efficiency decisions available to ABA practitioners. While the initial investment in template development requires time and skill, the compounding returns across a career and caseload are substantial. Understanding the concrete differences between these two approaches helps BCBAs make an informed decision about where to invest their graphing workflow development efforts.
This comparison is especially relevant for practitioners who currently spend significant time each week on graphing administration. The goal is not to reduce graphing quality — on the contrary, template-based approaches typically produce more consistent and professional graphs than manual approaches because formatting decisions are made once and applied uniformly. The goal is to redirect the time saved toward the clinical activities where behavior analysts add the most value.
The following table compares manual and template-based graphing across six dimensions relevant to ABA clinical practice.
| Factor | Evidence-Based Approach | Traditional Approach |
|---|---|---|
| Setup Time vs. Ongoing Efficiency | Manual: Low initial setup (open Excel, start entering data); high ongoing time cost as each graph requires repeated formatting decisions | Template-Based: Higher initial setup investment to build and refine templates; dramatically lower ongoing time cost as formatting is pre-configured |
| Consistency Across Clients | Manual: High variability in graph appearance across clients and over time; axis scales, label formats, and phase change line styles may differ without systematic reason | Template-Based: Consistent appearance across all clients and sessions; standardized formatting supports faster visual interpretation and professional documentation |
| Error Risk | Manual: Higher risk of data entry errors, axis scaling errors, and phase change line misplacement due to repeated manual operations on each graph | Template-Based: Lower ongoing error risk when formulas handle calculations and formatting is locked; initial template errors must be caught during setup and testing |
| Adaptability to Unusual Data | Manual: Highly flexible; can be adapted ad hoc for unusual data types, non-standard timeframes, or complex multi-behavior displays without template constraints | Template-Based: Requires deliberate template design to accommodate data variability; practitioners need a toolkit of templates for different graph types rather than a single universal template |
| Team Standardization | Manual: Each team member develops idiosyncratic graphing habits; supervisors spend more time reviewing graphs for errors and inconsistencies | Template-Based: Shared templates create organizational graphing standards; supervisors can review data faster across the team and focus on clinical analysis |
| Learning Curve | Manual: Requires only basic Excel knowledge; accessible to new practitioners with minimal training; efficient only for practitioners who are very fast at manual formatting | Template-Based: Requires investment in learning Excel charting features, formulas, and template management; returns increase with Excel fluency |
The ABA Clubhouse has 60+ on-demand CEUs including ethics, supervision, and clinical topics like this one. Plus a new live CEU every Wednesday.
Use this framework when approaching networking session: don't spend all your time graphing: excel and graphing tips in your practice:
Does the data support a need for intervention? Is there a meaningful impact on the individual's quality of life, safety, or access to reinforcement?
YES → Proceed to assessment NO → Document reasoning, monitor
A functional assessment should guide intervention selection. Avoid defaulting to standard protocols without individual analysis. Consider environmental variables, setting events, and private events.
YES → Select evidence-based approach matched to function NO → Complete assessment first
Goals should be co-developed. Assent and informed consent are ethical requirements. The individual's preferences and values matter in selecting both goals and methods.
YES → Proceed with collaborative plan NO → Engage in shared decision-making
This course covers the clinical and ethical dimensions in detail 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 →We extended this decision guide with research from our library — dig into the peer-reviewed studies behind each approach, in plain-English summaries written for BCBAs.
280 research articles with practitioner takeaways
279 research articles with practitioner takeaways
258 research articles with practitioner takeaways
1 BACB General CEUs · $0 · BehaviorLive
Research-backed educational guide
Research-backed answers for behavior analysts
You earn CEUs from a dozen different places. Upload any certificate — from here, your employer, conferences, wherever — and always know exactly where you stand. Learning, Ethics, Supervision, all handled.
No credit card required. Cancel anytime.
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.