I have a table of data with two columns which I need to display in a chart. I want to add a trendline to that chart in order to predict future data before it's added. I am looking to see if there is a way, presumably using VBA, to get excel to automatically change the trendline type to the type with the best fit to the data as new data is added to the table. For example, let's say I have the following data:
Looking at that data, it's easy to see that that data has a linear trend. But now let's say we add a point with coordinates X = 1200, Y = 8. In this new example, a linear fit is no longer the best option and the data is more precisely fit to a polynomial, logarithmic, or some other type of trendline. I am looking for excel to change the trendline type to whichever one gives the closest fit to the data as I expand the chart.