Creating "cliffs" in an area chart
 

If you change the 350s to 345 and the 400s to 395
then highlight the entire array, then use xy-scatter
lines only/finish, you'll get what you want and can
see it pretty well.


CurlerBob wrote:

6/1/2008 Â*350
6/23/2008 350
7/18/2008 350
8/1/2008 Â*400
9/1/2008 Â*400

Creating "cliffs" in an area chart
 

I am trying to put together a chart that creates "cliffs" when I change from
one value to another. For example I have the following data:

6/1/2008 350
6/23/2008 350
7/18/2008 350
8/1/2008 400
9/1/2008 400

What I want the chart to show is a flat line at 350 from 6/1/2008 to
8/1/2008 and then a flat line at 400 from 8/1/2008 until 9/1/2008. Besides
adding a dummy line into my row at 8/1/2008, is there another way?

Creating "cliffs" in an area chart
 

"CurlerBob" wrote in message
...
I am trying to put together a chart that creates "cliffs" when I change
from
one value to another. For example I have the following data:

6/1/2008 350
6/23/2008 350
7/18/2008 350
8/1/2008 400
9/1/2008 400

What I want the chart to show is a flat line at 350 from 6/1/2008 to
8/1/2008 and then a flat line at 400 from 8/1/2008 until 9/1/2008.
Besides
adding a dummy line into my row at 8/1/2008, is there another way?

That's what you need to do, insert a row with a duplicate of the date where
the transition occurs, so that date has both Y values.
/sig