Step/Staircase Charts

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

SPR wrote:
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

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

In article ,
says...
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

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
_______

dvt wrote:
SPR wrote:

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

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

"SPR" wrote in message
...
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

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.


"dvt" wrote in message ...
SPR wrote:
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

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

"dvt" wrote in message ...
SPR wrote:
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