Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Breakpoint will not stop Excel subroutine | Excel Discussion (Misc queries) | |||
Text Columns Negative Numbers Upgrade Excel? | Excel Discussion (Misc queries) | |||
How do I stop excel automatically changing my date to 2005? | Excel Discussion (Misc queries) | |||
Calculating Cells causes Excel to stop responding | Excel Discussion (Misc queries) | |||
Excel converts Mapped drive to UNC - How to stop? | Links and Linking in Excel |