3 Replies Latest reply on Dec 22, 2016 10:08 AM by Norbert Maijoor

    How to combine actual/forecast in 1 line and updated based on date

    stephen.ta.0

      Hi,  I am trying to create a chart that shows the "actual" line combined with the "forecast" line without using a dual axis.

       

      In addition to that I want the chart to auto update if present week date has passed than use "actual" if not then show forecast line.

       

      Here is an example of my data.  Thanks

       

      DateAmountForecasted Amount
      1/1/201635
      1/8/2016109.5
      1/15/20161514
      1/22/20162018.5
      1/29/20162523
      2/5/20163027.5
      2/12/20163532
      2/19/20164036.5
      2/26/20164541
      3/4/20165045.5

                                                                      

      DateAmountForecasted Amount
      1/1/201635
      1/8/2016109.5
      1/15/20161514
      1/22/20162018.5
      1/29/20162523
      2/5/20163027.5
      2/12/20163532
      2/19/20164036.5
      2/26/20164541
      3/4/20165045.5