Bar Chart: Expression label inside the bar

[#1]

Hi all,

I'm facing an issue.

- I've a bar chart that i'll turn into a waterfall using a bar offset for each expression

- This bar char is composed of 5 expressions.

I would like to have in each bar the label of the expression.

Any Idea?

[alexandros17]

The only way is (if you have a fixed number of bars) go to tab "Presentation" and in "text in chart" you can add text (even vertically)

hope it helps

[Gysbert_Wassenaar]

Use the dual function: dual('MyLabel', myexpression). Replace MyLabel with the label of the expression and myexpression with the expression itself. The bar will use the text MyLabel to display in the bar and the value of myexpression for the length of the bar.

[#4]

go to properties of bar chart

clik on  Number tab

select Expression Default value

then write in symbol = test

then test as a label for expression.

see the attachement.

[#5 · Accepted solution]

Based on Gysbert answer,

Dual('MyLabel' & chr(10) & num(MyExpression, '0.0%'), MyExpression)

I have now both Expression Name and it's value by the top of the bar.

Many Thanks.

[#6]

Hi, my current chart expression is using :     =$(vTotalCompliance)  which is a %'age rate.

My Label is Unit

If I try to use  Dual(Unit,$(vTotalCompliance)) the label is not appearing within each bar segment.

Do  you have any suggestions?

Many thanks for your time

[wagnepat]

Hi Gysbert,

I tried your function but somehow it doesn't work (below you see the expression and the dual function (dark blue = expressen, lightblue = dual function)).

Do you have any idea what I can that it works?

Thank you,

Patrick