Home |
Search |
Today's Posts |
#1
|
|||
|
|||
plot
How do I do a stairstep plot? Vertical lines have length one.
Horizontal lines can have any length. John Adams Bethlehem, PA |
#2
|
|||
|
|||
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
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a 3-dimensional plot in Excel? | Charts and Charting in Excel | |||
Continuous series plot | Charts and Charting in Excel | |||
Can I copy x-y scatter plot data direct from one plot to another? | Charts and Charting in Excel | |||
Plot Wizard -- "Not enough system resources to display completely. | Charts and Charting in Excel | |||
Contour plot | Charts and Charting in Excel |