4 Replies Latest reply on Oct 31, 2018 1:48 AM by Cédric Tran

    Show difference between actual and forecast in the same column

    NeedHelpThanks

      Hi everybody,

       

      I'm currently struggling with showing the difference between Actual and Forecast in a useful manner.

       

      I am trying to use a bar graph with stacked bars.

       

      I have two values: the actual value and the forecast value.

       

      As I can't share my workbook because the data is internal, I will show you a simple example here for better understanding of my problem.

       

      I want my bar to look like this:

       

      The actual value is 20000, the forecast value is 25000, the difference is calculated.

       

      I would be very thankful for any help.

       

       

      Best regards,

       

      Moritz