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!
--
Sue W.
"Jon Peltier" wrote:
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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"jjbud44" wrote in message
...
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.
--
Sue W.