Hi,

As Tushar has already pointed out the way to get the Area to vertically
drop to zero rather than slope down to zero by the next period is to
shortern the data range references for those series.

As you will be adding future years data at some point it might be worth
looking at creating dynamic named ranges for your data series.
Here are 2 examples.
http://www.tushar-mehta.com/excel/ne...rts/index.html
http://peltiertech.com/Excel/Charts/Dynamics.html

Cheers
Andy

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!

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info