Remember Me?

#1
November 11th 05, 10:46 PM
 John Posts: n/a
plot

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

Bethlehem, PA

#2
November 12th 05, 01:30 AM
 DOR Posts: n/a
plot

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

#3
November 12th 05, 10:49 PM
 John Posts: n/a
plot

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?

Bethlehem, PA

#4
November 20th 05, 05:14 AM posted to microsoft.public.excel.worksheet.functions
 DOR Posts: n/a
plot

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post dharmik Charts and Charting in Excel 1 October 4th 05 03:08 AM Chris Charts and Charting in Excel 2 June 3rd 05 01:20 PM Andrew Charts and Charting in Excel 1 April 26th 05 12:27 AM ojv Charts and Charting in Excel 2 January 10th 05 03:17 PM John W. Mordosky Charts and Charting in Excel 5 December 16th 04 03:04 PM

All times are GMT +1. The time now is 12:31 PM.