Line Charts Issue - Displaying Values in Percentages.

Hi,

I have a Line Chart and the Z axis is in percentages. But the values are not getting displayed in %. ie, 80% is appearing as just 80. It is not the case with Bar Graphs as I am able to show them by changing the number format to custom, but is not the case with Line.

Please help me. Thanks.

Regards,
Guru


Guru Prasadh (BOB member since 2008-10-29)

Just to know,did you try to format number of the column,like number>custom>0%.It should work i guess.


ajitha :india: (BOB member since 2008-07-28)

Hi Ajitha,

I did format it to percent as required, but what it changed was that the z axis values are coming out as percentage and not not the value displayed on the chart is appended with the percentage.

See the attached image.

Thanks
Guru
Line Chart issue.JPG


Guru Prasadh (BOB member since 2008-10-29)

Hi,
try to change the format of Data values and not the Axis columns in the Properties window


gokulBalaji :india: (BOB member since 2006-01-03)