trend line help

  • Thread starter Thread starter Edge
  • Start date Start date
E

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
 
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
 
Back
Top