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...
seiscons I'm experiencing the same thing all of a sudden - I noticed it 7/20. Not only do I see the error message, but all of the trendline equations somehow are now turned on (I had them off before).
I noticed the equations but assumed I must have displayed them. Thanks for that. There is something definitely going on here and I suspect it is a result of a recent update. Are you also using Excel 2016 and updating it regularly, Bonnie?