Hide/change colour on stacked bar segments, to get "Floating bars"

[#1]

Hi all,

I want to be able to make a stacked bar chart for show the movement in profits per month, where I can show the effect of each P&L line on profit.

In Excel, I can easily change the segment settings to show no lines or colour, but I have no idea how to do this in QV (see the example below for reference)

Any suggestions?

[CELAMBARASAN · Accepted solution]

Hi,

     Do you have 2 expressions?if so

     Use invisible option for that expression(which has the limit).

or

     use Bar offset you find that on clicking the + icon of the expression.

Celambarasan

[#3]

The invisible option wasn't possible for the effect I wanted, but Bar Offset certainly was.

Thanks Celambarasan