andrew.ward
New Member
- Joined
- May 5, 2002
- Messages
- 26
Hi all,
I have plotting a trend line through some raw data. There is an option that allows me to display the equation for this trend line.
I need to use this trend line to create some interpolated values.
I am able to manually copy the equation from the chart into a cell. However, is there a way of doing this automatically (via VBA, excel functions or some other means) so that the equation changes when the raw data and consequential trend line change?
Thanks heaps,
Andrew
I have plotting a trend line through some raw data. There is an option that allows me to display the equation for this trend line.
I need to use this trend line to create some interpolated values.
I am able to manually copy the equation from the chart into a cell. However, is there a way of doing this automatically (via VBA, excel functions or some other means) so that the equation changes when the raw data and consequential trend line change?
Thanks heaps,
Andrew