#1   Report Post  
John
 
Posts: n/a
Default plot

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

John Adams
Bethlehem, PA

  #2   Report Post  
DOR
 
Posts: n/a
Default 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   Report Post  
John
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DOR
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make a 3-dimensional plot in Excel? John W. Mordosky Charts and Charting in Excel 6 April 3rd 23 06:58 PM
Continuous series plot dharmik Charts and Charting in Excel 1 October 4th 05 03:08 AM
Can I copy x-y scatter plot data direct from one plot to another? Chris Charts and Charting in Excel 2 June 3rd 05 01:20 PM
Plot Wizard -- "Not enough system resources to display completely. Andrew Charts and Charting in Excel 1 April 26th 05 12:27 AM
Contour plot ojv Charts and Charting in Excel 2 January 10th 05 04:17 PM


All times are GMT +1. The time now is 08:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"