If Jon's example happens to not work for an Area chart,
another option would be to add a triangle autoshape over
the Nov - Dec area. You can then size the shape
appropriately and blend the color of the shape into the
background of the chart to cause that part of the Area
chart not to appear. For example, if the background of
the chart is gray and the area is blue, you would color
the shape gray to cover the top of the blue background.
You might have to do a little more formatting after that
to make it look "clean".

John Mansfield

-----Original Message-----
I have created an Area chart that shows January through
December across the
bottom axis. The chart shows data for each month. I have
data entered through
November, so the chart area should END at November, but
it doesn't. It
gradually keeps tapering until it gets to December. I
want it to STOP at
November. How can I change this? I have looked through
all the options, but
am missing it. Please help.

Thank you. :)

Avrilon

.