plot

[John]

How do I do a stairstep plot? Vertical lines have length one.
Horizontal lines can have any length.

John Adams
Bethlehem, PA

 

[DOR]

The following set of X and Y values plot as a stairstep plot, using an
XY (Scattter) plot, with lines and no markers. In my version of XL
(2002) this is the bottom right icon that shows when you select XY
(Scatter) plot.

X Y
1 1
2 1
2 2
5 2
5 3
6 3

Note the ploy of repeating an X value with the Y value one more than
the previous value (to give you the step-up of one), then repeating the
Y value for the the next X, to give you the horizontal line.

Is this what you want?

HTH

 

[John]

Thank you for your response. My explanation of the problem was
incomplete. I had hoped that excel had a program that would plot stair
steps.

My problem is illustrated by the following example. Z can have any
length, but its entries are always 0 or 1. (X,Y) are the coordinates of
points in a scatter plot.

Z X Y
0 1 0
1 2 0
0 2 1
1 3 1
4 1
4 2

Can excel compute X and Y for any given Z?

John Adams
Bethlehem, PA

 

[DOR]

Sorry for not getting back to you sooner; I have been away from the
forum.

Excel cannot directly plot the type of stairstep plot that is available
in the advanced math programs, such as MatLab, but the QI add-ins may
have what you want. See:

http://qimacros.com/index.html