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

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/comm...excel.charting

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

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

"HQDEARTHY" wrote in message
...
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/comm...excel.charting