View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
jjbud44 jjbud44 is offline
external usenet poster
 
Posts: 5
Default Slope line in stacked area chart

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.