7 Replies Latest reply on Mar 1, 2016 2:38 PM by ryan.angus

    Stacked column chart subtracting negative values


      I have a table with an amount field containing positive and negative numbers.  I'd like to create a stacked column chart, that doesn't put the negative values below the 0 axis, i.e. the absolute value of the negatives is stacked on top of the (positive values minus the negatives).  Wow, that sounds confusing, so I'll try and explain:


      Header 1Header 2Header 3
      Record 1income100
      Record 2expenditure-10


      I'd like the column to be stacked with income displayed as 90 and y displayed as 10.  Ultimately, the goal is to show the total value, with income as 1 colour and expenditure as another.  Hope this makes sense!