Excel should STOP the "zero or negative ..in log plot" error msg

[Guest]

Is there anyway to make the "zero and negative numbers cannot be plotted in
log plots..." 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 "I
Agree" 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 "I Agree" in the message pane.

http://www.microsoft.com/office/com...f30e7cbf30&dg=microsoft.public.excel.charting

 

[Bernard Liengme]

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