Step/Staircase Charts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SPR - 30 Sep 2003 10:11 GMT

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

Reply to this Message

dvt - 30 Sep 2003 13:45 GMT

> Hello,
>
[quoted text clipped - 15 lines]
>
> 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

Reply to this Message

Jon Peltier - 30 Sep 2003 17:30 GMT

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
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

>>Hello,
>>
[quoted text clipped - 38 lines]
> Dave
> dvt at psu dot edu

Reply to this Message

Evan - 30 Sep 2003 20:20 GMT

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.

> > Hello,
> >
[quoted text clipped - 38 lines]
> Dave
> dvt at psu dot edu

Reply to this Message

Evan - 30 Sep 2003 20:27 GMT

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

> > Hello,
> >
[quoted text clipped - 38 lines]
> Dave
> dvt at psu dot edu

Reply to this Message

Tushar Mehta - 30 Sep 2003 17:12 GMT

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

Signature

Regards,

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

> Hello,
>
[quoted text clipped - 15 lines]
>
> Regards

Reply to this Message

Bernard Liengme - 30 Sep 2003 18:47 GMT

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

> Hello,
>
[quoted text clipped - 15 lines]
>
> Regards

Reply to this Message