MS Excel Problem

R4Z0R · Sep 4, 2005, 07:34 AM

Well i've got a real serious problem, i need to make a line graph from my results but it doesn't seem to want to make one, i've actually tried all the options but this is what i get every time

Anyone know a way to actually create the graph with results in it?

md5 · Sep 4, 2005, 12:45 PM

Try the XY (Scatter) chart type, it seems that's the one you want to use with the data you have - choose the third one (where the points are connected without markers)

R4Z0R · Sep 4, 2005, 03:00 PM

figured out a way to make it work but it takes a loong time, i need to rearrange all the columns horizontally (into rows) for it to work (well atleast it did work like that), is it possible to do that automatically and not having to click on every single cell and move it?