Forums | Hello Guest, Login or Register | > > L4Y Files: No longer here! < <
  Levels-4-You : Lounge : Excel help [Forum Rules]  


Back to Forum Thread List

cyrus5   Posted 22nd Jun 2006 1:05pm
[CP] Director
L4Y Member
Post 201 / 241

hey peeps, slightly different topic from normal. Google and Microsoft have failed me...

I want to take data in the format:


and produce a line scatter graph thus:



I want each block to be a seperate series. Excel seems to want me to add each by hand, which is painful since there is about 1000 lines worth. Basicly the data is a set of line segments in 2d, spat out by an algorithm i'm writing at work and I want to be able to varify its drawing the correct thing.

I guess I could write something to display the data resonably quickly, or write a macro if it came to it, I just wondered if anyone knows how to do it in excel.

I just wanted to select it all, click make graph and let excel sort it; it seems like a reasonable request for excel to be able to split the data into series when it hits the blank lines between blocks of data. retarded software.

Al
Only the dead have seen the end of war - Plato
I think it would be a good idea. - Mahatma Gandhi, when asked what he thought of Western civilisation.
cyrus5.co.uk!  
 Modified Jun 22nd, 01:09pm by cyrus5



Copyright © 2000-2020 Levels-4-You
Your request was handled in 0.07 seconds.