Waterfall chart question

[BiggusDoggus]

Hi

So I have a waterfall chart.

And here is the data:

Want I want to have is the bars to the right of the black target column to descend, not ascend, to the point where they meet the final gray column.

I have both the black and gray column set as "total".

For the life of me I can't work out how to do that, or if it's even possible.

Any help greatly appreciated thanks!

 

[BiggusDoggus]

Never mind - sorted it. Simply changed the positives to negatives and vice versa for those values to the right of the target column.