Pop up Warnings

[Guest]

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

 

[Earl Kiosterud]

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).

--
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?

 

[Jon Peltier]

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