How to Make a Multiple Baseline Graph in Excel

Written by nicole newman
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Make a Multiple Baseline Graph in Excel
Baseline graphs can be easily made in Excel. (NA/AbleStock.com/Getty Images)

Multiple baseline graphs track two or more well-defined phenomenons that occur within an experiment. In the study, a subject is tracked over time following a pre-intervention condition. Intervention occurs at staggered times. The subject is tracked throughout the study, independent of other baselines. Examples of baseline experiments include treatments for alcohol overconsumption and food phobias. Fortunately, there is a process within the Excel suite that tracks baseline data in an efficient manner. The software helps eliminate mistakes that can be made while creating a traditional multiple baseline graph.

Skill level:
Moderately Easy

Other People Are Reading

Things you need

  • Excel software
  • Data

Show MoreHide

Instructions

  1. 1

    Type in your data into an Excel worksheet in which each column represents a separate baseline condition.

  2. 2

    Label the first row of each column with the condition name.

  3. 3

    Highlight the data you wish to include in the graph. Click on the "Chart Wizard" icon in the toolbar and select the standard line graph. Press "Next".

  4. 4

    Click on the vertical axis , then select the "Scale" tab to change the scaling on the y axis so that vertical axis hangs over the horizontal axis.

  5. 5

    Input the same minimum value for the "x" and "y" axes. Click "OK."

  6. 6

    Draw phase changes using the line tool in the toolbar. Add text boxes as well to label each condition.

  7. 7

    Click on one of the axes and modify the font size to make room for your additional baseline graphs.

  8. 8

    Input the data for the second graph on the same data sheet you used for your first graph.

  9. 9

    Highlight only the data you would like to include in the second graph.

  10. 10

    Open the chart wizard. Save the new graph as an object in your first graph.

  11. 11

    Repeat steps 1 through 6.

Tips and warnings

  • Count row numbers to ensure that each graph is the same size.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.