G
gtguess
A friend asked me this question. I don't use x-y scatter in Excel, but
it was frustrating to not be able to answer him back. I'm sure it's a
simple answer. Does anyone know? Thanks.
I have a simple set of data - 20 sets in all.
They all have the same x's, different y's (of course).
You know how you double-click on a line (x-y scatter) to pull up the
line/data properties, right? Where you can adjust the symbol and line
type,
etc... You can also adjust the order in which they are seen in the
legend.
After putting 14 sets on one graph, the rest cannot be re-arranged
allong
with the first 14. What I mean is, I put in a 15th line of data that
belongs in the legend next to data number 6. When I double-click on
#15,
all I see is #15, not the other 14, thus not allowing me to move the
15th
one "up" to a spot below #6.
Likewise, when I place data set #16 into the graph, when I try to
re-arrange
the order, all I see are #15 and #16, not #1-14. ARGH!
Does this make sense? Any suggestions?
it was frustrating to not be able to answer him back. I'm sure it's a
simple answer. Does anyone know? Thanks.
I have a simple set of data - 20 sets in all.
They all have the same x's, different y's (of course).
You know how you double-click on a line (x-y scatter) to pull up the
line/data properties, right? Where you can adjust the symbol and line
type,
etc... You can also adjust the order in which they are seen in the
legend.
After putting 14 sets on one graph, the rest cannot be re-arranged
allong
with the first 14. What I mean is, I put in a 15th line of data that
belongs in the legend next to data number 6. When I double-click on
#15,
all I see is #15, not the other 14, thus not allowing me to move the
15th
one "up" to a spot below #6.
Likewise, when I place data set #16 into the graph, when I try to
re-arrange
the order, all I see are #15 and #16, not #1-14. ARGH!
Does this make sense? Any suggestions?