Trend Line - break

B

bob

A time series of sales was increasing to a specific date when an event
occured. From then the sales declined. Can two trend lines be shown on
the one chart? the first to the date of the event and the other
subsequent.
 
A

Andy Pope

Hi,

A trendline is based on a series of data. Therefore to get your 2
trendlines based on the values pre and post event you will need to have
2 series. One based on pre event dates and the other on post. You can
format these 2 series to appear the same.

Cheers
Andy
 
Top