Friday, January 13, 2012

How to Create a Multiple Baseline Graph in Excel 2010


1. Type the label for your first baseline into cell A1. Type the label for your first intervention into cell B1, the next baseline in C1 and the next intervention in D1. Continue for as many baselines and interventions as you want to show in your graph.
2. Enter the data for the first baseline in column A. Enter the data for the first intervention in column B starting on the first row after the last entry in column A. Accordingly, you will have blank cells in column B where there is data in column A and blank cells in column A where there is data in column B. Continue for all of the columns so that each new set of data starts in the row below the last entry in the previous column.
3. Click and drag from cell A1 to the lower-right corner of your data. Click on the 'Insert' tab and choose 'Line' from the 'Charts' section. The multiple-baseline chart will be created with the baselines and interventions showing as separate lines on the chart.

Blogger news