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...
It's frustrating that this is still happening. The trendline error and re-appearing equation issue is happening to some users on my team (but not others) in the same template spreadsheet where manually fixing each series it's happening with is not a good option. Is there any solution to fix this permanently? I can't even effectively troubleshoot since it's not happening on my own computer.
EW_86 Frustrating indeed, but not sure if you saw my "temporary" fix which is simply to make the trendline formula transparent and then the Trendline Error will no longer show. See my previous post for screenshots.
