Pop up Warnings

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John Sinclair - 18 Dec 2003 22:16 GMT

I frequently work with log charts and am constantly bombarded with the following pop-up warning "Warning -- zero or negative numbers can not be plotted on log charts correctly ...." Everytime this annoying pop up comes up you have to click OK to continue -- an incredible distraction and waste of time when it approaches 100+ times a day. This is driving me crazy but I can not find a switch to turn this off. Any suggestions

Reply to this Message

Earl Kiosterud - 19 Dec 2003 05:23 GMT

John,

Check your chart data for zero or negative values. On a log scale, that
sends a point past all known galaxies (and doesn't stop there).

Signature

Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

> I frequently work with log charts and am constantly bombarded with the following pop-up warning "Warning -- zero or negative numbers can not be

plotted on log charts correctly ...." Everytime this annoying pop up comes
up you have to click OK to continue -- an incredible distraction and waste
of time when it approaches 100+ times a day. This is driving me crazy but I
can not find a switch to turn this off. Any suggestions?

Reply to this Message

Jon Peltier - 19 Dec 2003 13:48 GMT

If the zeros result from formulas that return 0, just change 0 in the
formula to NA(), which puts the #N/A error in the cell but doesn't mess
up the chart. If the zeros are at the beginning or end of the range of
data, it's easy enough to make a dynamic chart to include only values

>0; for dynamic charting examples and hints, see:

http://www.geocities.com/jonpeltier/Excel/Charts/Dynamics.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

> John,
>
> Check your chart data for zero or negative values. On a log scale, that
> sends a point past all known galaxies (and doesn't stop there).

Reply to this Message