Chart Help

[SEALs1230]

Hi,
I'm working on a project for school. This is my first time using Excel. I have 4 data tables with 7 columns (distance, 5 trials, and avg time) and 4 rows (4 different distances). I'm trying to make a graph with the avg time as the x-axis and the distance as the y axis. I need to put the data from the four different tables onto one graph. Using a different line for each table (One chart with 4 lines, representing the 4 different data sets). I have been trying for 2 hours to figure out what I'm sure is an easy task for you guys. I've tried everything I can think of, having never used excel before, I'm sure its not much. If anyone can help me out it would be greatly appreciated. Thanks.

 

[Alisa]

Start the chart wizard, choose 'line' as the chart type.
When you click next, a box called data range will probably popup. Click on the tab behind it that says "Series". There you can enter each series individually. Where it says "values" is where you put your y values in, and where it says category x is where you put in your x values. Hopefully that will get you started.
Alisa