...ive got a number of excel graphs - X, Y scatters.
the graphs are lumped together into sets of three i.e.
1) X, Y scatter of system at time t.
2) X, Y scatter of system at time t+1
3) X, Y scatter of system at time t+2.
right, i want to produce a master graph, which consists of these three graphs, they need to be stacked. I can just cut and paste them into word individually, but its a pain if i need to ammend the document, especially as its for publication, I.E. if i move one of the graphs, i want them all to move and if i resize one, i want them to be all scaled too.
ive looked in excel and i cant see this option.
HELP!
just have 3 different data series on the same XY scatter plot?
Assuming you havent got constant values for one of the variables i.e. x = 1, 2, 3, 4 for all sets of Y data you just need to edit the data ranges for each series so make series 1 something like x vals: =Sheet1!$A$1:$A$5 y vals: = =Sheet1!$B$1:$B$5 then series 2 x vals: =Sheet1!$C$1:$C$5 y vals = =Sheet1!$D$1:$D$5
Jobs a goodun I think.
Quote from: funkychicken9000just have 3 different data series on the same XY scatter plot?
not ideal as it looks cluttered and i have problems getting the line formatting correct, to distinguish the data points when the articles are printed...
Quote from: funkychicken9000just have 3 different data series on the same XY scatter plot?
Yup - one common x-y axis with 3 plots