entering matching data for line charts
If you are plotting Y against X values, XY (confusingly named as scatter) is
the option you should be using (and you can, of course, include lines,
either with or without point markers).
Line graph (named to cause confusion) is not usually the right option in
those circumstances.
--
David Biddulph
"johnston" wrote in message
...
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
|