7 Replies Latest reply on Oct 1, 2018 6:01 PM by lei.chen.0

    Waterfall chart with actual vs target line

    Steve Demanovich


      I am creating a waterfall chart that shows target values for each category, but I want to add a reference line that shows actual progress toward each target.  I'm stuck on calculating the "padding" that would indicate where this reference line originates.  See picture below - the gray shaded columns are subtotals, the red circles indicate where I've added the actuals gantt line but they are not starting where the waterfall bar starts. Thanks in advance for any advice!