MS Excel Problem

R4Z0R · Sep 4, 2005, 08: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, 01: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, 04: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?

Sep 4, 2005, 08:34 AM	#1
R4Z0R DriverHeaven Junior Member Join Date: Mar 2005 Posts: 43 Rep Power: 0	MS Excel Problem 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? __________________ [color=blue]AMD A64 X2 4400+(Tolledo)@280x10[/color] [color=blue]2 GB (4x512MB) G.Skill GBGH 2-2-2-5 [/color] [color=blue]PowerColor [color=blue]X1900XTx@690/820(1640Mhz DDR)[/color][/color] [color=blue]3x250GB 7200RPM SATA HDs [/color] [color=blue]Plextor PX-716A & LiteOn [/color][color=blue]16x DVD Drive[/color] [color=blue]Hercules Game Theater XP 7.1 sound card[/color]

Sep 4, 2005, 01:45 PM	#2
md5 DriverHeaven Senior Member Join Date: Dec 2004 Location: Inside DriverHeaven Posts: 856 Rep Power: 32	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) __________________

Sep 4, 2005, 04:00 PM	#3
R4Z0R DriverHeaven Junior Member Join Date: Mar 2005 Posts: 43 Rep Power: 0	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? __________________ [color=blue]AMD A64 X2 4400+(Tolledo)@280x10[/color] [color=blue]2 GB (4x512MB) G.Skill GBGH 2-2-2-5 [/color] [color=blue]PowerColor [color=blue]X1900XTx@690/820(1640Mhz DDR)[/color][/color] [color=blue]3x250GB 7200RPM SATA HDs [/color] [color=blue]Plextor PX-716A & LiteOn [/color][color=blue]16x DVD Drive[/color] [color=blue]Hercules Game Theater XP 7.1 sound card[/color]