Stepwise plots
Stepwise plots
(OP)
Dear all,
My issue is interval or stepwise plots similar to those in the portrayed illustration (soil parameters versus depth). I could not find a direct way to plot them so I had to use an IF statement. The IF statement I used has also a problem that is, if the value is not the same for at least two consecutive cells, the stepwise pattern is disrupted. I'm also attaching the Excel file I used (Excel 2013). I need a stepwise plot since the soil properties are often measured as a spatial average over a depth interval and not a single point along the investigated vertical. Is there an easy way around this? My datasets contain usually no more than 60 interval values. Depth along the X-axis would be all right as well.
My issue is interval or stepwise plots similar to those in the portrayed illustration (soil parameters versus depth). I could not find a direct way to plot them so I had to use an IF statement. The IF statement I used has also a problem that is, if the value is not the same for at least two consecutive cells, the stepwise pattern is disrupted. I'm also attaching the Excel file I used (Excel 2013). I need a stepwise plot since the soil properties are often measured as a spatial average over a depth interval and not a single point along the investigated vertical. Is there an easy way around this? My datasets contain usually no more than 60 interval values. Depth along the X-axis would be all right as well.

RE: Stepwise plots
Your file apparently has some problems, as my laptop indicates...
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: Stepwise plots
I will have a look and respond later.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Stepwise plots
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
[IMG http://tinyurl.com/7ofakss]
Need help writing a question or understanding a reply? forum1529: Translation Assistance for Engineers
Of course I can. I can do anything. I can do absolutely anything. I'm an expert!
There is a homework forum hosted by engineering.com: http://www.engineering.com/AskForum/aff/32.aspx
RE: Stepwise plots
RE: Stepwise plots
www.mccoy.it
RE: Stepwise plots
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
[IMG http://tinyurl.com/7ofakss]
Need help writing a question or understanding a reply? forum1529: Translation Assistance for Engineers
Of course I can. I can do anything. I can do absolutely anything. I'm an expert!
There is a homework forum hosted by engineering.com: http://www.engineering.com/AskForum/aff/32.aspx
RE: Stepwise plots
I'd like to process the data of one of my latest geotehnica investigations. I'm going to attach it here. First column, depth. Other 4 columns, N20, Number of penetrometer blows per 20 centimeters of depth. I can visualize immediately a plot like this one:
But I'm not able to visualize immediately a stepwise plot of the same data. Data vectors should look like the edges of overlapping bar graphs. That is, each data should have a lenght of 20 cm interval depth.
www.mccoy.it
RE: Stepwise plots
I applied Named Ranges to the source data using Create Names in TOP row.
The Formula in B3 and following. (B2 contains 0 hard coded)
B3: =IF($A3=$A2,INDEX(INDIRECT(B$1),MATCH($A3,INDIRECT($A$1),0),1),B2)
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: Stepwise plots
A2: 0.2
A3: 0.2
A4: = A2+.2
copy A4 down as far as needed.
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: Stepwise plots
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: Stepwise plots
I'm going to attach the graph so that the desired effect is clear to everyone.
www.mccoy.it
RE: Stepwise plots
With the data as in the sample file:
In Row 5, Columns I to M enter 1,2,3,4,5
In Row 6, Columns I to M enter 0, =B6, =C6, =D6. =E6 (i.e. 0, then values from first row of data)
In Column H from row 6 downwards enter 1, 1, then =H6+1 and copy down as far as required.
In I7: =INDEX($A$6:$E$81,$H6,I$5)
In J7: =INDEX($A$6:$E$81,$H7,J$5) and copy across to Column M
Copy I7:M7 down as far as required.
See attached file.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Stepwise plots
www.mccoy.it