4 Replies Latest reply on Mar 18, 2018 6:52 PM by ce.lin

    Dual axis bar chart with line for variance


      Hello All,


      I'm currently have a workbook with donations and donation goal data. I've built a dual axis bar chart to show the donations and donation goal, but would like to add one of the following features

      - line chart with labels showing the variance OR
      - some way of showing the variance number above the bars in a clear way to as to avoid confusion on what the number is indicating.


      Also, is there a way of using If statements in a tool tip? I'm trying to make it so the I can say <volunteers> had donations of <donations> which represents a (GAIN or LOSS based on if the number is positive or negative) <variance> over their goal.


      I've attached the workbook I have been working on. Thanks in advance!