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