Printer Friendly
The Free Library
22,741,889 articles and books

Designing multiple baseline graphs using Microsoft Excel[TM].

Single-subject design graphs are critical elements in displaying research results in applied behavior analysis Some of the information in this article may not be verified by . It should be checked for inaccuracies and modified to cite reliable sources.

Applied behavior analysis (ABA)
. However, developing a graph that conveys the researcher's results as well as adheres to a manuscript preparation checklist are sometimes daunting daunt  
tr.v. daunt·ed, daunt·ing, daunts
To abate the courage of; discourage. See Synonyms at dismay.

[Middle English daunten, from Old French danter, from Latin
 experiences. This article is intended to provide the reader with a basic understanding of how to create a multiple baseline experimental design graph using Microsoft Excel (tool) Microsoft Excel - A spreadsheet program from Microsoft, part of their Microsoft Office suite of productivity tools for Microsoft Windows and Macintosh. Excel is probably the most widely used spreadsheet in the world.

Latest version: Excel 97, as of 1997-01-14.

Keywords: single-subject graphs, designing graphs, software


Single-subject design graphs (e.g., reversal, multiple baseline) are critical elements in displaying research results in applied behavior analysis. However, developing a graph that conveys the researcher's results as well as adheres to a manuscript preparation checklist are sometimes daunting experiences. This article is intended to provide the reader with a basic understanding of how to create a multiple baseline experimental design graph using Microsoft Excel[TM]. However, these directions assume an intermediate level of understanding of Excel[TM], such as the function of various Excel toolbars. These detailed instructions will act as a good starting point Noun 1. starting point - earliest limiting point
terminus a quo

commencement, get-go, offset, outset, showtime, starting time, beginning, start, kickoff, first - the time at which something is supposed to begin; "they got an early start"; "she knew from the
 when initially constructing graphs. However, readers are cautioned in using the directions as guides not as rules as they evolve through the graph construction process.

Carr CARR Carrier
CARR Customer Acceptance Readiness Review
CARR Carrollton Railroad
CARR Corrective Action Request and Report
CARR City Area Rural Rides (Texas)
CARR Configuration Audit Readiness Review
CARR Customer Acceptance Requirements Review
 & Burkholder (1998) provided us with a great service in writing one of the first articles that described how to design single-subject graphs using Microsoft Excel[TM]. Even though there are several published articles that teach how to design single-subject graphs such as reversal graphs (e.g., Carr & Burkholder, 1998; Moran Moran

equitable councillor to King Feredach. [Irish Hist.: Brewer Dictionary, 728]

See : Justice
 & Hirschbine, 2002), the authors have no knowledge of an article that clearly describes how to construct a multiple baseline graph. Following the instructions in this article will allow the reader to construct multiple baseline graphs on Excel[TM] that conform to Verb 1. conform to - satisfy a condition or restriction; "Does this paper meet the requirements for the degree?"
fit, meet

coordinate - be co-ordinated; "These activities coordinate well"
 the Manuscript preparation checklist in the Journal of Applied Behavior Analysis The Journal of Applied Behavior Analysis (JABA) was established in 1968 as a The Journal of Applied Behavior Analysis is a peer-reviewed, psychology journal, that publishes research about applications of the experimental analysis of behavior to problems of social importance.  (2000).

Creating a Multiple Baseline Design Graph

Entering Data into the Spreadsheet

When you open Excel you will see columns (labeled A, B, C...) that represent values of the dependent variable and rows (labeled 1, 2, 3...) that show the sessions, days, etc. As shown in Figure 1 (at the end of this article), enter all of your data (e.g. baseline) in column "A", beginning with A1, using one cell for each datum point Any reference point of known or assumed coordinates from which calculation or measurements may be taken. See also pinpoint. . The only exception will be that each participant (or setting, or behavior) will be entered into a different column. For example, I have three participants, the first person's data will go in column A, the second set of data will go in column B, and the third set of data will go in column C.

For each new phase (e.g., baseline, intervention, return to baseline) enter data in the same column (e.g., column "A"). When finished, all data points for the first participant, setting, or behavior should be in a continuous line in the "A" column. All data points for the second participant, setting, or behavior should be in a continuous line in the "B" column, and so on until all data have been entered.

The primary reason for entering the data this way is to make your data entry less hectic hec·tic  
1. Characterized by intense activity, confusion, or haste: "There was nothing feverish or hectic about his vigor" Erik Erikson.

, because you will be entering all of your data (e.g., participants, setting, etc.). Another reason is so that the x-axis numbers are correctly aligned with the tick tick: see mite.

Any of some 825 parasitic arachnid species (suborder Ixodida, order Parasitiformes), found worldwide. Adults may be slightly more than an inch (30 mm) long, but most species are much smaller.

The easiest way to ensure that the different graphs (also known as legs) in your multiple baseline graphs are equivalent is to create one graph and copy it. Using the mouse, starting with the last datum point, highlight all of the cells containing data points (this will highlight cells a shaded color) in column "A" only. DO NOT HIGHLIGHT THE OTHER COLUMNS. Left click on the Chart Wizard icon (picture of a bar graph). Choose (XY) SCATTER scat·ter
1. To cause to separate and go in different directions.

2. To separate and go in different directions; disperse.

3. To deflect radiation or particles.

 and press FINISH. The data points for the first participant, setting, or behavior will be graphed. You will want to modify the graph, before proceeding so you have one complete graph complete graph - A graph which has a link between every pair of nodes. A complete bipartite graph can be partitioned into two subsets of nodes such that each node is joined to every node in the other subset. .

Modifying Graph Features

Format plot area. To format the plot area, move the cursor (1) The symbol used to point to some element on screen. On Windows, Mac and other graphics-based screens, it is also called a "pointer," and it changes shape as it is moved with the mouse into different areas of the application.  onto any part of the gray background and double click. You will see a chart titled FORMAT PLOT AREA. In the BORDER section left click NONE and under AREA left click NONE. Click OK to finish. The gray backgrounds and borderlines should be gone.

Move your cursor into the chart area. (move cursor towards the chart until you see "chart area" popping up underneath the cursor). In the chart area double click, and a box titled FORMAT CHART AREA will appear. You will see three different tabs: PATTERNS, FONT, and PROPERTIES. For the time being do not worry about PROPERTIES.

Patterns. Left click NONE for BORDER. Leave AREA as AUTOMATIC

Font. You will be given the opportunity to select you choice of font, style and size. When finished left click OK.

Chart Options. Go up to the toolbar (e.g., File, Edit, View, etc.) and left click on CHART and left click on CHART OPTIONS. This will permit you to change the rest of your graph features. (hint: your graph must be highlighted by having four squares on outer sides of graph before the CHART label will appear in the toolbar). You will see TITLES, AXES axes

[L., Gr.] plural of axis. The straight lines which intersect at right angles and on which graphs are drawn. Usually the horizontal axis is the x-axis and the vertical one the y-axis. Called also axes of reference.

Titles. Put in your labels for the X-axis and Y-axis lines. Do not select OK.

Axes. You will not have to change these unless you would like to remove the X-axis or Y-axis lines.

Gridlines. You will see four (4) different types of gridlines. Select the type of gridlines you would like by clicking the white box next to the gridline name, and a check mark will appear. As you change gridlines patterns, the small graph to the right will display the changes. If you would like to remove all gridlines from your graph, make sure there are no check marks in the boxes next to the gridlines. Do not select OK.

Legend. Remove the legend from the graph by left clicking in the white box next to SHOW LEGEND so there is no check mark in the box.

Data labels. This will enable you to place datum The singular form of data; for example, one datum. It is rarely used, and data, its plural form, is commonly used for both singular and plural.  values next to each datum point. When you are done click OK.

Change numbers on X-axis. Move cursor on one of the x-axis numbers and double left click on it, to bring up FORMAT AXIS. You will see the following labels: patterns, scale, font, number, and alignment. I will briefly discuss the function of each of these.

The PATTERNS section this allows you to change "tick label/markings" on your graph as well as to choose if you would like an axis line (subheading sub·head·ing  
See subhead.


the heading of a subdivision of a piece of writing

Noun 1.
 "lines") to be present or absent from your graph. Most people like to have an axis line, so keep the mark on AUTOMATIC.

The SCALE section allows you to modify your X-axis scale. Keep all of the numbers the same under the "minimum" and "maximum" headings: these tell the graph where to start and finish numbering depending on how many entries you put in your Excel spreadsheet. For the "major unit" heading select a number of spaces you want between each number: For example, enter 1 to show every number between the "minimum" and "maximum", 2 to show every number, 5 to show every fifth number, and so on. Most like to either do 1 or 2.

The FONT section allows you to modify your font size or type for the axis numbers here.

The NUMBER section includes the categories you can select for your X-axis numbers (e.g., list your numbers as percentages, times, fractions).

The ALLIGNMENT section allows you to modify the alignment of the X-axis numbers. The word "text" shows you how the axis numbers should be aligned. To modify alignment, either click on one of the diamond symbols on the graph, or place cursor on the word "text" and move up or down using your mouse.

After finished modifying you graph axis, press OK.

Change numbers on Y-axis. To change the numbers on the Y-axis, double click on a y-axis number, and follow the above directions (changing x-axis numbers).

Bring zero (0) up off X-axis. Double click on a y-axis number, and in FORMAT AXIS go to SCALE. Under "minimum" enter -1 and under "value (x) axis crosses at" headings, enter -0.5. Press OK. Your graph should have the first number as being -1, followed by the other numbers.

Move zero (0) off Y-axis. Double click on an x-axis number, and in FORMAT AXIS go to SCALE. Under "minimum" enter -1 and under "value (x) axis crosses at" headings, enter -0.5. Press OK. Your graph should have the first number as being -1, followed by the other numbers.

Get rid of the -1 on Y-axis and X-axis. On you drawing tool left click on the text box icon (looks like college rule paper). Go to the -1 and, using your mouse, click and hold left button down and drag to form a box that fits around the number. Release left mouse button.

Double click on outside (your cursor will form a four sided arrow) of the text box you just formed, and this will take you to FORMAT TEXT BOX. Under the FORMAT TEXT BOX click on COLORS AND LINES. Go to FILL, and then under COLOR, select AUTOMATIC, and the color of the fill should be white. This tells Excel to fill in your textbox with white, just like white-out. Go to LINE, and select NO LINE. Select OK when finished.

Your textbox should be filled in white, and this will cover up your -1 on the y-axis. You can always find the text box by moving your cursor to bottom of the y-axis and clicking until the text box reappears. This way to can modify the size of the textbox whenever.

Changing data point symbols. Place cursor onto a datum point and left click twice. Under PATTERNS there is a subtitle sub·ti·tle  
1. A secondary, usually explanatory title, as of a literary work.

2. A printed translation of the dialogue of a foreign-language film shown at the bottom of the screen.

 called MARKER, select the type of datum point would like as well as the size of the datum point. Go to the subtitle LINE and select AUTOMATIC, this will connect all of your data points.

Completing the Multiple Baseline Graph

Now that you have one complete graph, click on the "chart area" to highlight the entire graph (you will see eight small boxes surrounding the graph). Go to your toolbar (i.e., File, Edit), left click EDIT and left click on COPY. Using your cursor left click on an Excel spreadsheet cell that is below the first graph. Go up to your toolbar again, left click EDIT and left click PASTE. This will copy the graph and you should have two identical graphs. Repeat this set of directions until you have all of your multiple baseline legs.

The first graph (top graph) should have the data for the first participant, setting or behavior. You need to change the other graphs to reflect the data from the second participants, setting, or behavior. Start by clicking on the "chart area" of the second graph, to highlight graph.

Notice that the data under column A is highlighted with a blue line. Move your cursor onto the blue line that separates column A from column B, until you see the four-pointed arrow. Hold your left mouse button down, and drag the cursor over to column B until the data in column B is highlighted with a blue line. Release the left mouse button. Move cursor onto a bottom square of the blue box until a slanted arrow appears. Hold left mouse button down and drag down until all data in column B are encircled en·cir·cle  
tr.v. en·cir·cled, en·cir·cling, en·cir·cles
1. To form a circle around; surround. See Synonyms at surround.

2. To move or go around completely; make a circuit of.
 by the blue box. The second graph of your multiple baseline should have the data of the second participant, setting, or behavior.

Repeat the above step for each additional graph until all of the data for each participant, setting, or behavior is graphed. You might notice that each multiple baseline leg has a different set of X-axis and Y-axis values. In order to make all legs similar, make sure each leg has the same X-axis and Y-axis values by left clicking twice on either the X-axis or the Y-axis line and follow the directions in the section labeled:

Change numbers on X-axis and Change numbers on Y-axis.

Aligning the Legs of Multiple Baseline

Go to the second leg of your multiple baseline and move cursor into "chart area". Hold left mouse button down and drag graph up until the dotted lines are below the X-axis tick marks of the first graph. Repeat directions until all multiple baseline legs are aligned. (Note: the legs do not have to be perfectly aligned with each other)

Move cursor into "chart area" of the first leg and left click once. Hold CTRL See control key.

ctrl - control
 button down and left click once in "chart area" of each of the remaining legs. Release CTRL button. Move cursor to drawing toolbar, left click on DRAW, left click on ALIGN align (līn),
v to move the teeth into their proper positions to conform to the line of occlusion.
 OR DISTRIBUTE, and left click on ALIGN LEFT. Left click again on DRAW, left click ALIGN OR DISTRIBUTE, and left click on DISTRIBUTE VERTICALLY.

Hint: after this step, do not click in the Chart Area or Plot Area of any of your legs, because with this step you have made your legs into one continuous graph. If you do click in either the Chart Area or Plot Area, just repeat the steps of this step.

Putting in Condition Labels

Go to the drawing toolbar and left click on textbox icon (icon of a piece of paper). Move cursor above first condition (e.g., baseline). Left click once and a box will appear. Type the label of the condition in the box. Center the label by left clicking once on edge of textbox, hold the left mouse button down and drag the condition label into place.

Eliminating Lines Around Textbox

Move cursor to a side of the textbox until a four-arrow cursor appears. Double click. In the FORMAT TEXT BOX select FONT, and change the font and size of the condition label. Next, select COLORS AND LINES, and under LINE you will see COLOR. Left click on down arrow (on left side of color not of the white race; - commonly meaning, esp. in the United States, of negro blood, pure or mixed.

See also: Color
 box) and select NO LINE. Press OK, and the lines surrounding the textbox should be gone.

Copying the Textbox

Without moving your cursor, press CTRL + C and then CTRL + V to make a duplicate of the textbox. Use the cursor and move the second textbox above the next condition (e.g., intervention). Change the condition label, and proceed to complete the previous two steps until you have condition labels for each condition.

Making Y-Axis and X-Axis Labels

Go to the drawing toolbar and left click on textbox icon (icon of a piece of paper). Move cursor below X-axis line. Left click once and a box will appear. Type the label of the X-axis line. When done typing move the cursor to edge of textbox until a four-pointed arrow appears. Left click twice on edge of textbox. Left click once onto FONT and select the size and type of font. Then left click once on COLORS AND LINES, under FILL COLOR select AUTOMATIC. Select OK.

Moving cursor to the edge of the textbox, left click once on edge of textbox when you see the four-pointed arrow, and drag until centered over the original X-axis label. (For a Y-axis label follow the first four steps except put in your Y-axis label.)

Left click once on edge of textbox and a FORMAT TEXTBOX chart will appear. Left click on ALIGNMENT, under ORIENTATION, left click on the middle of the three boxes that have "text" written in them. Under TEXT ALIGNMENT, for VERTICAL select the choice that says, "center." Select OK.

Move cursor to the edge of Y-axis textbox, and move until it is centered between all multiple baseline legs. You will see eight circles surrounding the textbox. By placing cursor on any of the eight circles you can stretch the textbox until it covers all of the previous Y-axis labels. Left click somewhere on the spreadsheet other than on any of your multiple baseline graphs.

Eliminating Lines That Cross Condition Lines

To eliminate the data lines that cross condition lines, left click on each datum point on either side of the condition line. Move your cursor onto the line between the two highlighted data points and right click. In the information bar select FORMAT DATA POINT, find section labeled LINE, left click on NONE, and press OK. Voila, your line should be gone. Go back and repeat step to eliminate remaining lines.

Drawing Condition Lines

Go to your drawing tool bar, left click the slanted line (LINE comes up under your cursor). Move your cursor to the "X" axis of your last leg of your multiple baseline graph, place the cursor where you would like a condition line (e.g., between baseline and intervention) to be, hold your left click mouse button down, drag up until the line ends at the top of your first le g of your multiple baseline graph, as shown in Figure 2 (at the end of this article).

Move cursor anywhere on the line, get the four-pointed arrow, and right click once. Left click on EDIT POINTS. When you cursor is placed on the line, the cursor will now look like a small box. Move the cursor to the place on the condition line where you would like to change the condition line to a horizontal line (Descriptive Geometry & Drawing) a constructive line, either drawn or imagined, which passes through the point of sight, and is the chief line in the projection upon which all verticals are fixed, and upon which all vanishing points are found.

See also: Horizontal
 (i.e., in between two legs of the graph) and right click once. Left click on ADD POINT and a small box should now be on your condition line. Move cursor above that small box about an inch, hold left mouse button down and drag towards the left and down in order to make a horizontal line. Release left mouse button when line is long enough.

To make the diagonal line straight for the second leg, move cursor up to the top of the second leg, put cursor on the condition line, hold left mouse button down and drag towards the left until diagonal line is straight. Keep doing the last step until your condition line is complete for all legs of your multiple baseline graph, as shown in Figure 3 (at the end of this article).

Now you should have a completed multiple baseline graph. As you learn and become more efficient at making a multiple baseline graph, remember that these steps are mere guides not rules in how to design a graph. As you become more proficient pro·fi·cient  
Having or marked by an advanced degree of competence, as in an art, vocation, profession, or branch of learning.

An expert; an adept.
 and gain more confidence in designing singlesubject design graphs, you may begin to discover new ways, maybe even easier ways, to construct multiple baseline graphs.

Author Note

I would like to provide great thanks to Nate Smith for his help in providing feedback concerning Microsoft Excel[TM]. Correspondence should be addressed to


Carr, J. E., & Burkholder, E. O. (1998). Creating single-subject design graphs with Microsoft Excel. Journal of Applied Behavior Analysis, 31, 245-251.

Manuscript preparation checklist (2000). Journal of Applied Behavior Analysis, 33, 399-400.

Moran, D. J., & Hirschbine, B. (2002). Constructing single0subject reversal design graphs using Microsoft Excel[TM]: A comprehensive tutorial An instructional book or program that takes the user through a prescribed sequence of steps in order to learn a product. Contrast with documentation, which, although instructional, tends to group features and functions by category. See tutorials in this publication. . The Behavior Analyst Today, 3, 179-187.

Heidi L. Hillman Hillman was a famous British automobile marque, manufactured by the Rootes Group. It was based in Ryton-on-Dunsmore, near Coventry, England, from 1907 to 1976. Before 1907 the company had built bicycles.  & L. Keith Miller

For other people named Keith Miller, see Keith Miller (disambiguation).

Keith Ross Miller, MBE (28 November 1919-11 October 2004), was a famous Australian Test cricketer and World War II pilot.

University of Kansas The University of Kansas (often referred to as KU or just Kansas) is an institution of higher learning in Lawrence, Kansas. The main campus resides atop Mount Oread.  

Heidi Hillman

Department of Human Development and Family Life

4001 Dole Center

University of Kansas

Lawrence, KS. 66045.

Correspondence can also be sent via E-mail to:


L. Keith Miller, PhD

University of Kansas

Human Development & Family Life

4001 Dole Center

1000 Sunnyside Avenue

Lawrence, KS 66045

Tele: 785-864-4840




COPYRIGHT 2004 Behavior Analyst Online
No portion of this article can be reproduced without the express written permission from the copyright holder.
Copyright 2004 Gale, Cengage Learning. All rights reserved.

 Reader Opinion




Article Details
Printer friendly Cite/link Email Feedback
Author:Hillman, Heidi L.; Miller, L. Keith
Publication:The Behavior Analyst Today
Date:Sep 22, 2004
Previous Article:An empirical comparison of Cognitive Behavior Therapy (CBT) and Mode Deactivation Therapy (MDT) with adolescent males with conduct disorder and/or...
Next Article:An idiographic investigation of the effects of ability--and effort-based praise on math performance and persistence.

Related Articles
Knosys Announces New Addition to ProClarity 3.0 Product Family - ProClarity 3.0 for Microsoft Excel 2000.
Construction Cost Modeling Feature in BSD CostLink/CM.
Statistical software enhances learning.
Constructing single-subject reversal design graphs using microsoft Excel[TM]: a comprehensive tutorial.
Constructing single-subject reversal design graphs using microsoft word[TM]: a comprehensive tutorial.
A decade later: creating single-subject design graphs with Microsoft Excel 2007[TM].
Improving graduate students' graphing skills of multiple baseline designs with Microsoft Excel 2007.

Terms of use | Copyright © 2014 Farlex, Inc. | Feedback | For webmasters