Axis Layout

[carolin01]

Hi,

Could anybody help me with my chart layout:

I would like to have tousands seperators on my first axis and my secondary axis should be shown in %.

Unter Numbers in the chart properties I used #.##0 for my values on the first axis and the same shown in Percent for my secondary axis. Nevertheless it is not shown correctly. Also I fixed the max value for my secondary axis to 1.0 but it still shows 1.1.

Any ideas?

Best regards

Carolin

[MK_QSL]

You can use like below

NUM(YourExpression, '#.##')

NUM(YourExpression, '#,##0.00%')

[Gysbert_Wassenaar]

Try changing the format of the values on the Number tab.

No idea why the static max value isn't honored. It works in my document.

[carolin01]

The number format is correct. I know that usually you would do this here but for some reason it´s not changing anything.

[carolin01]

Where should I implement this?

[PrashantSangle · Accepted solution]

Hi,

You can write Num() given by MRKachhiaIMP in your expression

Regards,

[carolin01]

Hi,

I tried but it didn´t work. My expression now:

Num((RangeSum(Above($(vCalcTotalYear1), 0, RowNo()))) /( vSumTotalSales), '#,##0.00%')

My chart now:

[PrashantSangle]

Hi,

do one more thing ,

Property->Expression->select Expression->select relative

regards,

[MK_QSL]

Max Dreamer. Today is your Lucky Day !!!

[MK_QSL]

GO to expression tab... instead of expression you can use this ....