Trend Line - break
 

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.

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

bob wrote:
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.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info