irritating warning for negative data on log charts
 

I know perfectly well that I can't plot negative values on a log chart. That
doesn't mean that my data doesn't have negative numbers in it. Is there any
way that anybody knows to disable this irritating message? My productivity
drops 100% because every time I scroll around in a sheet that happens to have
a negative number on a log chart somewhere, this irritating dialog pops up.

I don't want to have to build my own log charts that ignore negative numbers
(I could, but what's the point of a built-in log chart if you can't use it).
I don't want to have to write formulas for cells to make the offending
negative value "invisible" to the chart (we've tried dozens of ways, and they
all fail to be user-friendly at some level). What I want is to tell Excel
that I'm smart enough to know that when the chart has a hole in it, it's
because it couldn't plot the data. What's so hard about that?

This has frustrated me for years. Can anybody help?
--
Roger Stout, PE
Senior Research Scientist
ON Semiconductor