I'm sure this is naive. In Excel 2003 I'm trying to construct a line graph
in which there is is more than one set of matching x and y values. For
example, the data looks like this:
x1 y1 x2 y2
1/1/08 1 1/15/08 5
2/1/08 2 2/15/08 6
3/1/08 3 3/15/08 7
4/1/08 4

If I were drawing a scatter plot, I could enter matching x and y values, but
with a line graph I can plot the data only by rearranging it to look like
this.
x y1 y2
1/1/08 1
1/15/08 6
2/1/08 2
2/15/08 7
3/1/08 3
3/15/08 8
4/1/08 4

I'm sure there must be a simpler way, particularly if one has multiple data
sets. Any help would be appreciated.

Thanks,
johnston