How to display a number with a decimal as a percentage

[shadekitty]

I have a chart that contains data similar to

 

.51 and 1.0

 

I would like to display the numbers as 51% and 100%. I know how to add the % suffix, but I cannot determine how to move the decimals over to display the correct percentage. Is this something that I would need to do in the sharepoint list and change how the data itself is displayed for it to properly display in my chart?

 

Thanks!

[shadekitty]

No one else wants to take a stab at this? Is it because it isn't possible to do?

[Rahul Kumar]

Hi,

 

Sorry for the delay in reply. Yes, its possible. 

 

Please follow the steps given below and see if this works?

 

To show the scaling ranging from 0 to 100:

1. Please open the wizard go to "Number Formatting" 

2. In "Scales to be used" put "%,%" (without quotes) and 

3. In "Values of each Scale" put ".1,.1" (without quotes) 

4. Click on "Apply" and "Finish".

 

I hope this helps.

[MBCS]

I have an error with this solution. I'm able to get most of my values to show up correctly. (0.152 --> 15.2%). However, values under 10% do not show up correctly in my chart. If the value is under 10% (.10), the value just shows up on the chart without the scaling and % applied. So 0.031 just shows up on the chart as 0.031 instead of 3.1%.