Forum Discussion
Chart displaying "Trendline Error"
I have charts which plot linear data ranges with trendlines using named ranges and OFFSET to make the ranges dynamic. Sometimes the chart series data range is a pair of cells containing zeros. In t...
I found a way to turn this off. Under Chart Design, Add Chart Element, choose Trendline > None. And error goes away.
As the problem occurs when displaying trendlines I'm not surprised that removing the trendline removes the error message.