State Changes

[Alec Bowman]

I have some data which reflects chages in state between
TRUE and FALSE against time. Ideally I would like to plot
this using an XY scatter chart but unfortunately this
extrapolates between 0 and 1 over intervening time periods
resulting in a "saw tooth" rather than a "square wave"

Alec

 

[Bernard Liengme]

You will need each date to appear twice; firstly with its own value then
with its next-date's value
1-Feb-2004 TRUE ' its own value
1-Feb-2004 FALSE ' value borrowed from next date
8-Feb-2004 FALSE
etc

Suggest data for chart be placed on another sheet; this will make entering
the second-row stuff easy with formulas. Come back if more details needed.

Best wishes
Bernard
www.stfx.ca/people/bliengme

 

[Jon Peltier]

Alec -

In addition to Bernard's suggestion, you could try Tushar Mehta's step
chart approach (http://tushar-mehta.com). Or you could make a column
chart, which has bars either 1 or zero units tall. You may want to
double click the columns, and on the Options tab, change the gap width
from 150 to 0.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______