Replace that value by =NA()
....if I understand the question correctly!
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Tom Hayakawa" wrote in message
...
I have a line chart that keeps track of daily values and also monthly
totals.
At the end of the month the monthly values line takes a steep drop back to
an initial value for the first day of the new month. Is there any way to
delete this line segment and still use the series as a whole? There will
be
more than one month's worth of data displayed. Thanks!