How to Create Multiple Graphs in One Chart

1. Open your spreadsheet program and enter your two data sets into adjacent columns. Type a label for your data sets in the first row of each column. (Note: These instructions are based on Open Office Calc, a free spreadsheet program, but the process will be similar when using Microsoft Excel.)
2. Click and drag to select all of the cells whose data you wish to include in your chart, including the 'label' cells at the top of each column.
3. Click 'Insert' and then 'Chart.' Select 'Line' from the 'Choose a chart type' column. Select 'Lines and Points' from the icons on the right-hand side of the dialog box. Click 'Next.' Make sure the 'First row as label' box is checked and then 'Next' twice.
4. Type in a title for your chart, a subtitle (if desired) and names for the X axis and Y axis. Click 'Finish.'