plot
How do I do a stairstep plot? Vertical lines have length one.
Horizontal lines can have any length. John Adams Bethlehem, PA |
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 |
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? John Adams Bethlehem, PA |
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 |
All times are GMT +1. The time now is 02:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com