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!