If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Step/Staircase Charts
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 |
#3
|
|||
|
|||
Step/Staircase Charts
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 |
#4
|
|||
|
|||
Step/Staircase Charts
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 |
#5
|
|||
|
|||
Step/Staircase Charts
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 |
#6
|
|||
|
|||
Step/Staircase Charts
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 |
#7
|
|||
|
|||
Step/Staircase Charts
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 |
Thread Tools | |
Display Modes | |
|
|