Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Flat Trend Line

19 views
Skip to first unread message

forecastnovice

unread,
May 24, 2012, 6:57:20 PM5/24/12
to

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

Martin Brown

unread,
May 25, 2012, 3:07:40 AM5/25/12
to
ITYM AVERAGE()

--
Regards,
Martin Brown

Ross La Haye

unread,
May 27, 2012, 11:42:10 PM5/27/12
to
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...
0 new messages