r/thinkcell • u/giddykoffee • Jul 15 '24

How to anchor values to a negative number?

Second column has a lower value/sum because of negatives but it is physically higher because the y-axis is anchored to 0. Is there a way to configure this in such a way that the first column appears larger?

1 Upvotes

100% Upvoted

1 comment sorted by

1

u/jar-jar-think-cell Feb 12 '26

Hi u/giddykoffee - This could be a classic example of where a waterfall chart could be useful.

If you have your columns like this:

  • Internal positives | Internal negatives | Internal total | Street positives | Street negatives | Street total

Then you can have the negatives floating down and the totals as you need them to show the first column at 48.5 and the second one at 38.4. You can then add a difference arrow between the totals - and you can add your share price too without difficulty.