I don't think this is possible. My only suggestion would be to create
a formula and insert it into calc over the top of the graph. Not
elegant, but may work.
Paul
On Apr 5, 2005 5:56 AM, help hints for unsubscribed users
<[EMAIL PROTECTED]> wrote:
> Stealthsub <[EMAIL PROTECTED]> writes:
> >Paul,
> >Thanks for our reply.
> >I followed your instructions and, as noted, got the "formulas" for the
> >regression array in the spreadsheet cells:
> > {=LINEST(F3:F4;E3:E4)} {=LINEST(F3:F4;E3:E4)}
> >
> >and the "results" are:
> > 11.913 -$252,878
> >
> >
> >However, I want to display the equation on my graph as:
> > y = 11.913*(x2-x1) + 172,000
> >(My graph is a plot of mm/dd/yy dates on the x-axis and values on the
> >y-axis ---- thus at "0" date, the intercept is -$252,878.
> >But the equation I show has 172,000 as the "intercept" at the "x1" date.
> >
> >By double clicking on the chart and using "Insert ---> Statistics", I was
> >able to show the regression line of my points on the graph.
> >Now I would like to display the equation itself on the graph. I hope there
> >is an option to do this.
> >
> >I use Excel at work and am therefore familiar with showing "Trendlines" and
> >the option for displaying the equation and r-squared on the chart.
> >
> >Thanks.
> >
> >----- Original Message -----
> >From: "Paul" <[EMAIL PROTECTED]>
> >To: <[email protected]>; <[EMAIL PROTECTED]>
> >Sent: Sunday, April 03, 2005 6:47 PM
> >Subject: Re: [users] Displaying Regression Equation
> >
> >
> >> I'm guessing that your real question is how do I display formulas
> >> instead of the results. Reason is that there is no difference between
> >> other formulas and regression formulas...
> >>
> >> From OOo help :
> >> If you want to display the formulas in the cells, for example in the
> >> form =SUM(A1:B5), proceed as follows:
> >> 1.Choose Tools - Options - Spreadsheet - View.
> >> 2.In the Display area mark the Formulas box. Click OK.
> >> If you want to view the calculation results instead of the formula, do
> >> not mark the Formulas box.
> >>
> >> HTH, Paul
> >>
> >> On Apr 3, 2005 7:49 AM, Stealthsub <[EMAIL PROTECTED]> wrote:
> >>> How can I display the regression equation in my spreadsheet chart ?
> >>>
> >
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
