R
Reo Grande
Can this alert be turned off?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Some trendlines cannot be calculated from data containing negative or zero values
J
Jerry W. Lewis
In Excel 2000, XP, and 2003, This message occurs when you modify data
that is charted with a Logarithmic, Power, or Exponential trendline, in
such a way that refitting the trendline would essentially require taking
logarithms of negative numbers. Since Excel's functions (other than a
few in the Analysis ToolPak, which is a 3rd party Add-In that only ships
with Excel) are all restricted to real values, what do you think Excel
should do instead of warning you that it cannot do what you have asked
it to do?
Jerry
that is charted with a Logarithmic, Power, or Exponential trendline, in
such a way that refitting the trendline would essentially require taking
logarithms of negative numbers. Since Excel's functions (other than a
few in the Analysis ToolPak, which is a 3rd party Add-In that only ships
with Excel) are all restricted to real values, what do you think Excel
should do instead of warning you that it cannot do what you have asked
it to do?
Jerry
R
Reo Grande
Jerry W. Lewis said:In Excel 2000, XP, and 2003, This message occurs when you modify data
that is charted with a Logarithmic, Power, or Exponential trendline, in
such a way that refitting the trendline would essentially require taking
logarithms of negative numbers.
With dynamic ingestion of data on 3 second intervals with occasional zero
values in the data set that are of no significance the warning is pointless.
Since Excel's functions (other than a
few in the Analysis ToolPak, which is a 3rd party Add-In that only ships
with Excel) are all restricted to real values, what do you think Excel
should do instead of warning you that it cannot do what you have asked
it to do?
As per the original post I would like to turn the warning off because for my
purposes it is nothing more than an irritation.
Do you have a solution or are you just chastising?
J
Jerry W. Lewis
Again, you are asking Excel to fit a trendline, in a situation that is
impossible (log(0)=-infinity). Excel is simply telling you that you
have posed an impossible situation under the specified model, and it
doesn't know what to do. Turning off the warning (which as far as I
know, is not possible) would still not resolve the basic problem that
Excel does not know what you want it to do.
In what sense is zero data "of no significance"? If they should be
ignored entirely, use #N/A instead.
Jerry
impossible (log(0)=-infinity). Excel is simply telling you that you
have posed an impossible situation under the specified model, and it
doesn't know what to do. Turning off the warning (which as far as I
know, is not possible) would still not resolve the basic problem that
Excel does not know what you want it to do.
In what sense is zero data "of no significance"? If they should be
ignored entirely, use #N/A instead.
Jerry