Home > IT Answers > Microsoft Windows > Claculate slope & Intercept from line drawn in chart (Excel)
falfra
10 pts.
 Claculate slope & Intercept from line drawn in chart (Excel)
Microsoft Excel, VBA
Is there a way to compute the slope & intercept of a line (object) drawn on a chart in Excel using VBA? I have an X-Y chart with data and I want to have the flexibility of drawing my own "best-fit" line through the data. Thanks, Frank

Software/Hardware used:
EXCEL 2010
ASKED: March 1, 2013  8:13 PM
UPDATED: March 4, 2013  2:41 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question. falfra   10 pts. , Michael Tidmarsh   14,060 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _