#1   Report Post  
Posted to microsoft.public.excel.misc
Jay Somerset
 
Posts: n/a
Default Trend line in Excel

On Mon, 13 Feb 2006 09:34:28 -0600, deacs
wrote:


Thanks for the reply. Is there a way around this, so that I can plot the
power and exponential lines? Must I remove the negative numbers?

The data points I have represent monthly costs and I would like to make
projections based off of the raw numbers as reference points with other
bottoms up projections. The months with negative numbers are months
when there were returns within this cost category.

Thanks again for your help.



One way, although a bit clumsy, would be to add a constant to each number,
so that they are all positive. Plot your trend using whatever function you
choose, and then subtract the same constant from any projection that you
derive from the trend.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get Excel to tell me the angle of a line drbob2000 Excel Worksheet Functions 4 October 22nd 05 01:02 AM
how to change line spacing for text box in excel chart Anne Charts and Charting in Excel 1 October 5th 05 12:11 AM
How do I get a value of a calculated point on an excel line chart? klc6778 Charts and Charting in Excel 3 September 26th 05 02:17 AM
A 2 line text showing up in the Cell in Excel prints in 1 line Danny Excel Discussion (Misc queries) 6 July 12th 05 08:47 PM
Hints And Tips For New Posters In The Excel Newsgroups Gary Brown Excel Worksheet Functions 0 April 15th 05 05:47 PM


All times are GMT +1. The time now is 05:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"