Candlestick chart in spotfire with negative values

[Huy Nguyen 2]

I'm following the tutorial here to create candlestick charts

https://www.youtube.com/watchv=Oe_PZi42a_k&feature=emb_title

It works great if the data is positive, however if one of the data points (let's say start value) is less than 0 then the chart doesn't stack correctly anymore

The box that has value

[Dave Leigh]

The problem is caused by the first bar segment being drawn from 0 to the negative value and being drawn on top of the second segment. You can see the problem a little more clearly if we change the background color and move the first segment out of the way:

 

I don't believe there is a solution for this. Unless someone in the Community knows different...