If you convert to a time scale axis, you can make a sharp drop in an
area chart. You need two points for the X value (2006 here) where the
drop off occurs. Any continuing series uses the same value for both 2006
occurrances.

BigDept Dept1 Dept2
2005 200 100 150
2006 215 125 165
2006 215 0 0
2007 225 0 0
2008 235 0 0
2009 250 0 0

Plot the data in an area chart. At first 2006 appears twice along the X
axis. Choose Chart Options from the Chart menu, select the Axes tab, and
under Category Axis, check the Time Scale box. Now you get a sharp drop
off at 2006, but the dates are goofed up. Double click the axis, and on
the Number tab, select General, and you'll get your years back again.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Irenerz wrote:
I've reading reading posts, and I can't find a specific answer to my
question.

I have some data I want to plot in an area graph.
X-axis values go from 2005 to 2015.

For the first 5 categories I only have values for the 2005/2006 year. The
next categories I have all data from 2005 to 2015.

When I plot the area chart the first 5 series, with values in 2005 & 2006.
The area graph shows a drop off to zero in 2007.

My question is: Is there a way to not show the drop of from 2006-2007. I
have no value for that cell, but it still shows a drop off. Is there a way
to cut off the area at 2006 rather than having the area graph continue on.

Example:
Department 1: 2005: 10 / 2006: 20
Department 2: 2005: 25 / 2006: 35
Big Department: data for all 10 years.

Hopefully this makes sense. Thanks for your help in advance!