Hi,
Here is one way to get the area chart to stop dead at Novemeber instead
of sloping down to zero by December.
Ensure the axis is formatted as a time scale, right click the chart and
show the chart options dialog. The axis type should be Time-scale.
Automatic if the axis labels are really dates.
You will need to add an additional data point inbetween Nov and Dec with
the value November date repeated and a value of zero.
Cheers
Andy
Avrilon wrote:
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
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info