Use #N/A or equivalently NA() instead of 0 or text.

Jerry

Callan wrote:

I am using a line graph with 2 sets of series.
Can someone please tell me how to stop the graph from showing values after a
certain point in the series. If I use 0 or empty string ("") in the cells,
the graph continues with the line just on the bottom of the graph. I need a
condintional line as I have formual reffering to the "0". If that is possible.
Many thanks