Help Required: Y Axis have multiple dimension

[#1]

Hi All,

Y Axis have multiple dimentions named as YValue1 , YValue2, YValue3. The challenge is in YValue1 total sum is shown but in  YValue2 i have to show avg. The number format of YAxis i need to change when i select YValue1 it should show as number format but when i select YValue2 it should show as %.

File attached.

Thanks

MV

[cfz]

Hi Manish,

Try choosing an appropiate (for instance fixed to 2 decimals) Number Format Settings and then select Show in Porcent in the Number tab of the Properties of the object.

I hope it helps.

Carlos

[#3]

Thanks Carlos,

By doing this all values (including YValue1) will be show in percentage. But i want to show YValue1 as number format and rest as percetage format.

Hope i am able to explain my problem.

Thanks

MV

[#4]

Hi All,

Please suggest any solution to this problem.

Thanks

MV