creating a customized waterfall chart

[#1]

Hi All,

Want to create a waterfall kind of a chart (screenshot attached below). The bars above the line has an offset equal to the first blue colored bar but i am not able to create the bar below the line which the overlap between the first bar & the respective bars.

Any ideas for the same?

Thanks in Advance

Arun

[Anonymous]

Hello,

Every bar there should be a separate expression.

And then all you need to do is to give offset via expressions->(measure the offset to be given) + -->Bar Offset.

Here you need to write the blue bar's expression so that the offset is given according to it.

BR

Serhan

[#3]

Thanks for the reply.

I have already done that but my problem is the bar below the line. How to create that bar with a different color?

Thanks

Arun

[tresesco]

Expand the '+' sign of expression label->Background color, you can write expression there like =If(Sum(Sales)>100, red(), green())

[Anonymous]

Hello,

You can write another condition to Expressions->+-> Background Color.

There are color functions like rgb(), argb ().

You can change the color accordingly.

BR

Serhan

[michael_anthony]

It is a tough one to do.  I think you could achieve it by:

Create a dimension to represent each bar.  It doesn't need to link to anything else.  Put the dimension in the chart.

Create two expressions as a stacked bar chart.  The first one handles the -ve value and can have the offset, using If OR Pick (Match (.....)...,...,....) to calculate each value.  The second handles the +ve.  You can set the color expression as needed.