Hello everyone, this is my first post on this forum, so even though I read the rules I hope I don't step on anyone's toes.
I am trying to find a way to implement a trendline in a simple time series graph, but by selecting the two points on the graph directly.
Ideally, I'd need a small scroll down menu, click "add trend-line", select two points through which the trend-line would pass through, and then maybe add the r^2 and the equation somewhere.
This would allow me to add 3 or 4 trend-lines on a same graph, and show all the equations below the graph.
I can take care of all the small details of course, but for the major part, the actual data selection, does anyone have an idea how I could do this with a VBA macro ? (or 10?)
Thanks in advance, Nqsty
I am trying to find a way to implement a trendline in a simple time series graph, but by selecting the two points on the graph directly.
Ideally, I'd need a small scroll down menu, click "add trend-line", select two points through which the trend-line would pass through, and then maybe add the r^2 and the equation somewhere.
This would allow me to add 3 or 4 trend-lines on a same graph, and show all the equations below the graph.
I can take care of all the small details of course, but for the major part, the actual data selection, does anyone have an idea how I could do this with a VBA macro ? (or 10?)
Thanks in advance, Nqsty
