plotting multiple x y data on same graph

  • Thread starter Thread starter breegeek
  • Start date Start date
B

breegeek

my friend is pulling his hair out trying to plot something
for his engineering class and i figured id ask on the
board..

he has a large amount of data, grouped in twos. theres
about ten sets of two. each set he wants plotted as x and
y respectively, but all on the same line graphy. I think
he laid it out wrongly but he w3ont hear any of it and its
been a few years since i was using excel myself.

so how does one plot it out as thus on the same graph.

data looks something like this

x y x y x y
# # # # # #
# # # # # #
# # # # # # etc

thanks
 
If we assume the first two columns (say A1:B4) are a single data series,
that columns 3 and 4 (say C1:D4 are a second data series, etc..
Select the first set of data, make an XY chart.
EITHER
Select and copy the second set of data (C1:D4), click on chart to activate
it, use Edit|PasteSpecial->New Series (make sue to specify first column is
x-values and top row is header)
Do same for other data series.
OR
Right click,on chart; select Source Data fro popup menu
Open Series tab and add the new series by filling in the boxes (it is easier
to use the mouse to select each range since you need Sheet1!B1:B4 ..etc)
 
Back
Top