Flat Trend Line

[forecastnovice]

Hi,

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

thank you in advance for any and all suggestions

 

[Martin Brown]

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()

 

[Ross La Haye]

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.

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