In a range of your worksheet, convert the values into absolute values using
the ABS() worksheet function. For example, if the values are in column B,
starting in B2, in C2 enter

=ABS(B2)

and fill this formula down as far as you need. Plot this data and add a
trendline to this series.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"Lee" wrote in message
...
Hi,

I'm working on a Mechanical Engineering lab with a plot of data in the
form
of an absolute value function. Is there any solution to allow Excel to
plot
a line of best fit as an absolute value function?