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


G

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
 
Ad

Advertisements

B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top