+ Reply to Thread
Results 1 to 3 of 3

stepping chart

  1. #1
    Registered User
    Join Date
    07-07-2006
    Posts
    5

    stepping chart

    I'm having problems creating a chart for the following:
    Y-axis: value for a level (eg. interest rate)
    X-axis: time/date where the interval for x-values isn't fixed

    The chart must represent a horizontal line/bar until the next value is represented (like stages).

    Example:
    X.........................Y
    01/01/06...............4.2%
    01/03/06...............4.5%
    15/03/06...............4.4%
    01/08/06...............4.7%

    resulting in a horizontal line/bar on 4.2 until 01/03/06 stepping to 4.5% until....etc.

    Who can help me?

    Ron

  2. #2
    HEK
    Guest

    RE: stepping chart

    Ron, see a.o. : http://www.andypope.info/charts/stepchart.htm
    GL,
    Henk

    "Petje" wrote:

    >
    > I'm having problems creating a chart for the following:
    > Y-axis: value for a level (eg. interest rate)
    > X-axis: time/date where the interval for x-values isn't fixed
    >
    > The chart must represent a horizontal line/bar until the next value is
    > represented (like stages).
    >
    > Example:
    > X.........................Y
    > 01/01/06...............4.2%
    > 01/03/06...............4.5%
    > 15/03/06...............4.4%
    > 01/08/06...............4.7%
    >
    > resulting in a horizontal line/bar on 4.2 until 01/03/06 stepping to
    > 4.5% until....etc.
    >
    > Who can help me?
    >
    > Ron
    >
    >
    > --
    > Petje
    > ------------------------------------------------------------------------
    > Petje's Profile: http://www.excelforum.com/member.php...o&userid=36161
    > View this thread: http://www.excelforum.com/showthread...hreadid=559422
    >
    >


  3. #3
    Registered User
    Join Date
    07-07-2006
    Posts
    5
    Thanks,

    The use of XY scatter error bars chart did it.

    Ron

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1