plot a series of line segements, one for each row?

N

Nomen Nescio

say I have a table and the rows are of the form
X1 Y1 X2 Y2
which are the endpoints of line segments
I want to plot each row as a line segment,
each separate not joined to each other.
Can Excel do this?
(or can an alternative like Open Office do it?)
 
D

Del Cotter

say I have a table and the rows are of the form
X1 Y1 X2 Y2
which are the endpoints of line segments
I want to plot each row as a line segment,
each separate not joined to each other.

Format your data like this:

X Y
1
2

1
2

1
2

The blank rows between each pair will result in line segments instead of
continuous lines.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top