Hi,

I'm needing some help again in Excel. I have a downward sloping trend (determined by using the TREND function in Excel). I need to create a flat trend line based on the TREND data populated. The ultimate goal is to have a flat line versus a downward sloping trend line. From this data, I will continue with my modeling, but just need some help with this piece.

thank you in advance for any and all suggestions.

On 24/05/2012 23:57, forecastnovice wrote:
Hi,

I'm needing some help again in Excel. I have a downward sloping trend
(determined by using the TREND function in Excel). I need to create a
flat trend line based on the TREND data populated. The ultimate goal is
to have a flat line versus a downward sloping trend line. From this
data, I will continue with my modeling, but just need some help with
this piece.

thank you in advance for any and all suggestions.

ITYM AVERAGE()

--
Regards,
Martin Brown

On Thursday, May 24, 2012 5:57:20 PM UTC-5, forecastnovice wrote:
Hi,

I'm needing some help again in Excel. I have a downward sloping trend
(determined by using the TREND function in Excel). I need to create a
flat trend line based on the TREND data populated. The ultimate goal is
to have a flat line versus a downward sloping trend line. From this
data, I will continue with my modeling, but just need some help with
this piece.

thank you in advance for any and all suggestions.




--
forecastnovice

Following what Martin Brown noted, if you have a constant value in a column alongside your source data, you can then add that data to your chart, and this will display as a horizontal line... I do exactly this on a file I use at home...