I have a chart created from a bunch of data, using the "Scatter with Smooth Lines" option. Since this is from observed data, the lines have quite a bit of noise in them. I've created trend lines for each of them. I would post an image showing the chart but the forum won't allow me to. So, instead I'll try and explain what the image looks like. The y-axis is in terms of % values, ranging from 0.00% to 50.00%. The x-axis is in terms of calendar dates, ranging from 2/12/2020 to 2/29/2020. There are 7 solid lines that are based on observed data. There are 7 dotted lines matching the colors of the solid lines, and these are trend lines calculated by Excel. Most of them are logarithm functions but a few of them are quadratics because those fit the curves better.
What I want to do after this is have several cells = to the y value of the trend lines at x = 2/29/2020. I have absolutely no idea how to do this. I can show the function in the trend line options, but that doesn't actually get me what I need. I need the cell data that is getting information from the trend lines to update automatically as I update the source data for the solid lines. Also not really sure how I would convert "2/29/2020" into a value of x that would work in the function, but that's besides the point because I need a fully automated process.
There has to be some way to do this.
Bookmarks