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...
Very annoying indeed. I found a way to hide the Trendline Error by formatting the Trendline Label and making the text completely transparent.