Zero value i graph

[Jakob Austgulen]

Hello

I have a graph (chart) that my line goes down to zero.
I hope to find a ascii table to set the value so that the chartline stops
(do not goes to zero).

If I use right mouse button and "delete information", my value er deleted
and my linechart stops.
If I use "delete" the line goes to zero.



--


Jakob

[Barb Reinhardt]

I know of two ways to do this.

1. You can put the function NA() in the affected cells
2. Use TOOLS, OPTIONS, CHARTS ... and Plot empty cells as "not plotted"

Have a great day!

Barb Reinhardt

"Jakob Austgulen" <[email protected]> wrote in message
news:[email protected]...
> Hello
>
> I have a graph (chart) that my line goes down to zero.
> I hope to find a ascii table to set the value so that the chartline stops
> (do not goes to zero).
>
> If I use right mouse button and "delete information", my value er deleted
> and my linechart stops.
> If I use "delete" the line goes to zero.
>
>
>
> --
>
>
> Jakob
>
>

[Tushar Mehta]

Another option to Barb's suggestions is to use a named formula in the
graph along the lines of Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>, [email protected]
says...
> Hello
>
> I have a graph (chart) that my line goes down to zero.
> I hope to find a ascii table to set the value so that the chartline stops
> (do not goes to zero).
>
> If I use right mouse button and "delete information", my value er deleted
> and my linechart stops.
> If I use "delete" the line goes to zero.
>
>
>
>