Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel should display linear equation of line drawn on graph.
Make a graph (chart), draw a straight line on the graph. So what's the slope
and the intercept? An option to display the linear equation would quickly reveal both. Excel cells should be able to directly link to precise values of the coefficients of the equations displayed in a graph. I can't say how many times I've modeled a best fit only to find that a coefficient changed when my original data changed or that a manual entered coefficient wasn't precise enough and yielded a bad fit equation. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...excel.charting |
#2
|
|||
|
|||
Do you not know about the functions SLOPE, INTERCEPT ,LINEST, FORECAST and
TREND? Please read Help and come back if more info is needed. -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "landen99" wrote in message ... Make a graph (chart), draw a straight line on the graph. So what's the slope and the intercept? An option to display the linear equation would quickly reveal both. Excel cells should be able to directly link to precise values of the coefficients of the equations displayed in a graph. I can't say how many times I've modeled a best fit only to find that a coefficient changed when my original data changed or that a manual entered coefficient wasn't precise enough and yielded a bad fit equation. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...excel.charting |
#3
|
|||
|
|||
If that straight line was a trendline, then there is already an option
to display the equation (on the Options tab of the Add Trendline dialog), you just didn't use it. If you mean that you want to see equations for each line segment that connects two points, that would be a bit busy, since there is no guarantee that more than two points will lie on the same straight line. Jerry landen99 wrote: Make a graph (chart), draw a straight line on the graph. So what's the slope and the intercept? An option to display the linear equation would quickly reveal both. Excel cells should be able to directly link to precise values of the coefficients of the equations displayed in a graph. I can't say how many times I've modeled a best fit only to find that a coefficient changed when my original data changed or that a manual entered coefficient wasn't precise enough and yielded a bad fit equation. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...excel.charting |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get a value of a calculated point on an excel line chart? | Charts and Charting in Excel | |||
How to enter a two line column heading in excel | New Users to Excel | |||
Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
In Excel how can a number automatically display in text form | Excel Worksheet Functions | |||
How do I get the trendline equation from Excel to script? | Charts and Charting in Excel |