Step/Staircase Charts

[SPR]

Hello,


Could someone please adcise me how to get staircase charts
to work?

I have done these in the past with the XY scatter charts
(and without using error bars), but I cant get it to work
now.

My sample date would be something like

01-Oct-03 4.75
08-Oct-03 5.00
05-Nov-03 5.00
03-Dec-03 5.25
04-Feb-04 5.25
03-Mar-04 5.00

Regards

 

[dvt]

Hello,


Could someone please adcise me how to get staircase charts
to work?

I have done these in the past with the XY scatter charts
(and without using error bars), but I cant get it to work
now.

My sample date would be something like

01-Oct-03 4.75
08-Oct-03 5.00
05-Nov-03 5.00
03-Dec-03 5.25
04-Feb-04 5.25
03-Mar-04 5.00

Regards

I have one possible suggestion. Revise your data to look like this:

01-Oct-03 4.75
08-Oct-03 4.75
08-Oct-03 5.00
05-Nov-03 5.00
05-Nov-03 5.00
03-Dec-03 5.00
03-Dec-03 5.25
04-Feb-04 5.25
04-Feb-04 5.25

03-Mar-04 5.25
03-Mar-04 5.00

I added an extra data point in between your existing data points. The added
data points have the date of the *next* data point and the value of the
*previous* data point. Now do an XY scatter chart and I think you'll get
something that looks like a staircase.

Dave
dvt at psu dot edu

 

[Tushar Mehta]

If you are willing to use error bars, see the tutorial Excel | Charts |
'Step Chart' on my web site.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

The other approach, as detailed on Tushar Mehta's web site
(http://tushar-mehta.com, look for Step Charts in the list), does use
error bars but no extra points.

- Jon

 

[Bernard Liengme]

Hi,
Alter data as shown below. Every second row is a formula pointing to next
data and previous amount.
date amt
1-Oct-03 4.75
8-Oct-03 4.75
8-Oct-03 5
5-Nov-03 5
5-Nov-03 5
3-Dec-03 5
3-Dec-03 5.25
4-Feb-04 5.25
4-Feb-04 5.25
3-Mar-04 5.25
3-Mar-04 5
3-Mar-04 5


Best wishes
Bernard

 

[Evan]

Try

Row\Col C D E F G
10 x1 y1 =ROW(C$10)+INT((ROW()+1-ROW(C$10))/2) =INDIRECT("c"&J10)
=INDIRECT("d"&J10)
11 x2 y2 =ROW(C$10)+INT((ROW()+1-ROW(C$10))/2) =INDIRECT("c"&J11-1)
=INDIRECT("d"&J11)
12 x3 y3 ...
13 etc

Select E10:G11 and autofill down to twice the length of xy data in
Cols C & D.
Plot Col G vs F on an xy-chart. Still looking for a simpler way.
Above display may have wrapped.

 

[Evan]

In the previous post, formulas in Cols F & G should refer to Col E, not J.