How to Graph Multiple Series Using Excel

1. Type your data that will go on your x-axis in column A. Use row 1 as the title for your data and then a separate cell for each piece of data.
2. Type your first series of data in column B. Use row 1 as the title for your data and then a separate cell for each piece of data.
3. Type your next series of data in column C. Use row 1 as the title for your data and then a separate cell for each piece of data. Continue this pattern for each series.
4. Highlight every cell with a title or data in it. Highlight by going to cell A1, then press and hold shift while moving the cursor with your arrow keys.
5. Click 'Insert.'
6. Select 'Line' or 'Scatter.' The chart will then display on the spreadsheet.