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.
|