PC Review


Reply
Thread Tools Rate Thread

How can I put chart trendline equations into a MS Excel cell?

 
 
=?Utf-8?B?QkdLZWVuNjI5?=
Guest
Posts: n/a
 
      4th Aug 2006
I would like to automatically put trendline equations calculated and
displayed on the chart into a cell. Anyone know if this can be done and how
to do so?

Thanks.
 
Reply With Quote
 
 
 
 
Mike Middleton
Guest
Posts: n/a
 
      4th Aug 2006
BGKeen629 -

There are easy-to-enter worksheet functions and formulas corresponding to
each trendline type, but to do it "automatically" would likely require VBA,
depending on what you mean by "automatically."

- Mike
http://www.mikemiddleton.com

"BGKeen629" <(E-Mail Removed)> wrote in message
news:FCEE15F8-FEFE-41F5-B034-(E-Mail Removed)...
>I would like to automatically put trendline equations calculated and
> displayed on the chart into a cell. Anyone know if this can be done and
> how
> to do so?
>
> Thanks.



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trendline Equations in Excel 2003 tep Microsoft Excel Charting 7 15th Jul 2008 04:44 PM
Excel 2007 Trendline Equations Incorrect DanB Microsoft Excel Charting 6 3rd Jul 2008 10:24 AM
Access to Chart Trendline Equations in VB =?Utf-8?B?S01I?= Microsoft Excel Programming 3 12th Jul 2007 04:11 PM
Excel should update trendline equations when data is altered. =?Utf-8?B?Y3J5c3RhbA==?= Microsoft Excel Programming 0 4th Mar 2006 09:16 PM
trendline equations inserted directly to a cell =?Utf-8?B?U3V6eQ==?= Microsoft Excel Programming 6 23rd Nov 2005 04:17 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:08 PM.