trend line help

[Edge]

Hi there,

i have created a simple x,y scatter graph with a trend line. The trend
line has a formula attached to it, some thing in the form of y=100x-50
What Im trying to do is to take that formula and use it in the work
sheet to enter different values of x to get the y values.

It cant just be typed in to a box as the data in the chart will change
and therefore the trend line formula will change accordingly.

Does any one know how to have a copy of the current trend line formula
to use in the worksheet ???

Thanks,

michael

 

[Jerry W. Lewis]

Answered under microsoft.public.exce.charting

Please do not separately post the same question to multiple newsgroups.
If you think the question belongs in multiple newsgroups, then you
should address a single copy of the question to all the relevant groups,
so that replies will not be fragmented.

Jerry