I want to change the number precision in the trendline equation in
embeddded chart. How can I do that? I would like higher numbe
precision in a trendline equation

--
Harsh_Sha
-----------------------------------------------------------------------
Harsh_Shah's Profile: http://www.excelforum.com/member.php...fo&userid=2648
View this thread: http://www.excelforum.com/showthread.php?threadid=39750

Double click on the formula, and on the Number tab change the format. It is often
suggested to use a Scientific format with 15 decimal digits.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Harsh_Shah wrote:

I want to change the number precision in the trendline equation in a
embeddded chart. How can I do that? I would like higher number
precision in a trendline equation.

Thanks Jon.

I could figure out in excel. But I cannot find a way of changing the
number precision of a trendline equation to Scientific using VBA. It is
crucial for my project.

thanks,

harsh


--
Harsh_Shah
------------------------------------------------------------------------
Harsh_Shah's Profile: http://www.excelforum.com/member.php...o&userid=26484
View this thread: http://www.excelforum.com/showthread...hreadid=397500

On Sun, 21 Aug 2005 08:48:06 -0500, Harsh_Shah
wrote:


Thanks Jon.

I could figure out in excel. But I cannot find a way of changing the
number precision of a trendline equation to Scientific using VBA. It is
crucial for my project.

thanks,

harsh

A few years ago, Dave Braden posted VBA code to extract the data from a
trendline equation. You should be able to adapt this to your project.

See:

http://www.google.com/groups?selm=db....microsoft.com

If you have a recent version of Excel, 2003+, you may find that the LINEST
function is good enough for your tasks, too.


--ron

Turn on the macro recorder, then carry out the steps you want to automate. Recorded
code isn't particularly efficient, but it will at least give you the syntax.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Harsh_Shah wrote:

Thanks Jon.

I could figure out in excel. But I cannot find a way of changing the
number precision of a trendline equation to Scientific using VBA. It is
crucial for my project.

thanks,

harsh