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


--
Petje
------------------------------------------------------------------------
Petje's Profile: http://www.excelforum.com/member.php...o&userid=36161
View this thread: http://www.excelforum.com/showthread...hreadid=559422

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

stepping chart
 

Thanks,

The use of XY scatter error bars chart did it.

Ron


--
Petje
------------------------------------------------------------------------
Petje's Profile: http://www.excelforum.com/member.php...o&userid=36161
View this thread: http://www.excelforum.com/showthread...hreadid=559422