Left align labels inside barchart

[#1]

Hello,

Is it possible to align labels to the left when my values are inside the bar chart?

I have managed to get the values plotted inside the bar chart as I wanted, but the label is not obviously not in centered along all the bar chart, just centered with the bar where the number is inside.

So, it would be maybe nice to align the number to the left instead of center, can this be done?

Cheers,

Niko

[pipuindia99]

There is a way, instead of putting the values in Bar you can add those expressions in Text in Chart box and align the numbers to start of the Bar. so that the numbers will be in left always.

[Anonymous · Accepted solution]

Hi Niko,

By default the numbers inside are showing on center of line. If you want do it you need 2 expressions. See attached.

Regards!

[#4]

Hello Manuel,

This works otherwise perfectly, but when I try to set the number format, I only get 0,00

Cheers,

Niko

[Anonymous]

Hi Niko,

I am using Dual function, get format on expression and set on number Expression Default.

Dual(Num(Sum(Expression1),'#.##0'),0)

Regards!

[#6]

Ahh, it had to be inside the dual.. I tried to put it outside of the dual()

Now I only have to get the percent mark in place there too.. But thank you very much!

Cheers,

Niko

[#7]

Got that % also there.. Had to be also inside dual(), heh!

[Anonymous]

Hi Niko,

if you want on %, then Dual(Num(Sum(Expression1),'#.##0 %'),0)

Regards!!!