software

Is there anyway to make the quot;zero and negative numbers cannot be plotted in
log plots...quot; error message? It is really annoying as it goes off every 5
seconds when a plot has numbers like that. When dealing with big databases
it is not a big deal to have zeros in it and still want it plotted as a log
plot.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...excel.charting

Even Microsoft cannot override the laws of mathematics - what would you have
Excel use for LOG(zero)?
If you replace 0 by =NA() , which displays as #N/A, you will achieve the
desired effect - the point is ignored in the chart
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;HQDEARTHYquot; gt; wrote in message
news
gt; Is there anyway to make the quot;zero and negative numbers cannot be plotted
gt; in
gt; log plots...quot; error message? It is really annoying as it goes off every 5
gt; seconds when a plot has numbers like that. When dealing with big
gt; databases
gt; it is not a big deal to have zeros in it and still want it plotted as a
gt; log
gt; plot.
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow
gt; this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...excel.charting