Nick

Check out a dynamic range for the series that will stop at last data and
ignore "" cells.

Tushar Mehta has methods.

http://www.tushar-mehta.com/excel/ne...rts/index.html

Also Jon Peltier's site.

http://peltiertech.com/Excel/Charts/index.html#hdrDyno


Gord Dibben Excel MVP

On Wed, 11 May 2005 14:08:05 -0700, "Nick" <Nick @discussions.microsoft.com
wrote:

I have a sales worksheet that totals monthly from January thru December.

I plot the summary sales by month in a simple line chart.

The problem is that since the year is not completed, the line chart drops
off to zero for the month that total zero which makes it look like a sales
decline. I would like to make it just stop plotting at the last month with
sales.

I can do this manually by deleting the totals for each month but I would
prefer to use some kind of an "IF" statement and a "NULL" value but am unable
to find the correct mix.

Any ideas ? Thanks In advance. Nick.