2 Replies Latest reply: Jul 14, 2015 3:39 AM by Aaron Morgan RSS

    Chart Prediction / Forecast

    Phil Speight

      I have a line chart to show how many new starters and Leaves I have on a month by Month basis.  I want to create a forecast to show where I expect this will be by the end of the fiscal year.

       

      Although I can do a linear trend line, this overlays across the whole graph.  Is there any way I can set a trend line after my actual data so it only displays going forward from the most recent data point?

       

      i.e. 

       

      Month 1 actual = 10

      Month 2 actual = 20

      Month 3 actual = 30

      Month 4 Forecast = 40

      Month 5 Forecast = 50

      etc