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.

 

[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

 

[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/newsgroups/dynamic_charts/index.html

--
Regards,

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