entering matching data for line charts

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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


.

Relevant Pages

  • 3D Scatter plot in Excel
    ... How do I make a 3D scatter plot in Excel? ... the viewing angle of the 3D graph. ...
    (microsoft.public.excel.charting)
  • Re: entering matching data for line charts
    ... If you are plotting Y against X values, XY (confusingly named as scatter) is ... Line graph is not usually the right option in ... If I were drawing a scatter plot, I could enter matching x and y values, ...
    (microsoft.public.excel.charting)
  • Re: entering matching data for line charts
    ... If I use a scatter plot, ... adjust the x-axis so that the major divisions align with the first of each ... Line graph is not usually the right option in ... If I were drawing a scatter plot, I could enter matching x and y values, ...
    (microsoft.public.excel.charting)
  • how do I add functions together in an excel Chart?
    ... scatter plot on graph in excel. ... I then want to have excel add these ... Prev by Date: ...
    (microsoft.public.excel.charting)
  • Re: excel graph problem with axis scale
    ... Did you specify "scatter plot" as the graph type? ... Only the "scatter plot" actually plots the X-axis based on data values ... made a line graph of hemoglobin level (on vertical axis) vs day (horizontal ... the format x-axis window is still open and won't ...
    (microsoft.public.mac.office.excel)