Slope line in stacked area chart
 

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.

Slope line in stacked area chart
 

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.

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.

Slope line in stacked area chart
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"jjbud44" wrote in message
...
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.