Thread: Need to "not show" piece of line in graph

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
--
Callan

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

Thanks, but where must I use it?
Here's the line I have in the cell
=If(E6>0,E6,"") I tried to put the @N/A instead of (""). Doesn't work.
If there is no value I need the cell to be empty so that the graph does not
represent it on the line.
Thanks
--
Callan


"Jerry W. Lewis" wrote:

> 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
>
>

"Callan" <Callan@discussions.microsoft.com> wrote in message
news:38050521-665C-4D9A-83BE-33B4AEF29D0A@microsoft.com...
> "Jerry W. Lewis" wrote:
> > 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.

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

> Thanks, but where must I use it?
> Here's the line I have in the cell
> =If(E6>0,E6,"") I tried to put the @N/A instead of (""). Doesn't work.
> If there is no value I need the cell to be empty so that the graph does
not
> represent it on the line.

Don't use @N/A, use NA()
--
David Biddulph

Thanks alot! That was EXACTLY what I wanted. Thanks again!
--
Callan


"David Biddulph" wrote:

> "Callan" <Callan@discussions.microsoft.com> wrote in message
> news:38050521-665C-4D9A-83BE-33B4AEF29D0A@microsoft.com...
> > "Jerry W. Lewis" wrote:
> > > 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.
>
> > > Use #N/A or equivalently NA() instead of 0 or text.
>
> > Thanks, but where must I use it?
> > Here's the line I have in the cell
> > =If(E6>0,E6,"") I tried to put the @N/A instead of (""). Doesn't work.
> > If there is no value I need the cell to be empty so that the graph does
> not
> > represent it on the line.
>
> Don't use @N/A, use NA()
> --
> David Biddulph
>
>
>

Not @N/A, #N/A as in =IF(E6>0,E6,#N/A) or =IF(E6>0,E6,NA())

Jerry

Callan wrote:

> Thanks, but where must I use it?
> Here's the line I have in the cell
> =If(E6>0,E6,"") I tried to put the @N/A instead of (""). Doesn't work.
> If there is no value I need the cell to be empty so that the graph does not
> represent it on the line.
> Thanks