Trend Line - break

  • Thread starter Thread starter bob
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Here we go again 2
Determie Trend 2
How can I evaluate whether a trend is positive or negative? 6
Trend Lines (or Linest?) 2
Trend line for each 4
Manual Trend lines 1
Microsoft office2010 trend lines 1
coefficients of trend line 3

Back
Top