How to Make a Multiple Baseline Graph in Excel

1. Type in your data into an Excel worksheet in which each column represents a separate baseline condition.
2. Label the first row of each column with the condition name.
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. 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. Input the same minimum value for the 'x' and 'y' axes. Click 'OK.'
6. Draw phase changes using the line tool in the toolbar. Add text boxes as well to label each condition.
7. Click on one of the axes and modify the font size to make room for your additional baseline graphs.
8. Input the data for the second graph on the same data sheet you used for your first graph.
9. Highlight only the data you would like to include in the second graph.
10. Open the chart wizard. Save the new graph as an object in your first graph.
11. Repeat steps 1 through 6.