Slope line in stacked area chart

[Guest]

How can I change the slope between two points in a stacked area chart to be a
vertical line? My x axis is years, and where my data goes from 0 in year 1
to 100 in year 2, I get a slope upward --- but I don't want that; I want to
see a vertical line as the beginning of the area, at the year 1 point.

Thanks.

 

[Jon Peltier]

Put 100 instead of 0 into the cell for year 1 data. For a more refined
approach, see my response to the thread "Wonky Area Graph Problem", started
only a few minutes after yours.

- Jon

 

[Guest]

Jon,
That probably would have worked, if I hadn't oversimplified my problem. My
data actually goes from 0 in year 4 to 100 in year 5, and is stacked on top
of pre-existing data (shown as area in the chart).

I also looked at your reply to the "Wonky Area Graph Problem" thread, but if
I duplicate years in my data, I get duplicate years along my x-axis . . .

?????
Thanks!

 

[Jon Peltier]

You could duplicate the category data as long as they are numeric, then go
to Chart menu > Chart Options > Axes, and change the selection under
Category (X) Axis to Time Scale. This imposes the time-scale formatting that
vertically aligns points with the same category. Then double click the axis,
which shows some goofy date format, and change the number format to General.

- Jon