If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 news 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Adjustable Scroll Stop in Excel | Dr. Nonverbal | Worksheet Functions | 2 | October 10th, 2005 12:21 AM |
How to stop Excel from automatically selecting cells? | geekgirl33 | General Discussion | 1 | July 5th, 2005 11:50 PM |
How do i enter negative times in Excel & how can they be 'fiddled. | stuck! | General Discussion | 2 | April 7th, 2005 02:05 PM |
WHY | General Discussion | 9 | December 16th, 2004 12:49 AM | |
Stop Recording toolbar does not open in Excel 2003. | Lastword24 | Worksheet Functions | 4 | September 7th, 2004 10:38 PM |