Percent Signs Not Showing In Report

[CTQE]

We have a report coming in access db making a bar chart. Would like the data labels at the bottom of the bars to show a 2 decimal place % (ie:15.84%, 15.22%,....) for all bars.

It is a top 10 pareto, source data is from a query and when we try to put the % in as an &"%" at the Row Source box in the chart properties, and it didn't like the syntax. Same thing with trying to do a 1-(sum....) function.

Please help, need to post today company wide, YIKES! Thank you.

 

[converse]

Have you set the format (in the properties) to Percent?

If you want to do it manually with the row source, and the data is from say Field1

Then the row source needs to be changed to =[Field1] & "%"

Hope that helps.

 

[CTQE]

Thanks for the rapid response, greatly appreciated!

The number is coming into my graph from an expression.
So when I sort the data, it sorts it in this manner:

156
157
2
3
456
478
5
etc.

I would like for it to sort numerically not alpha.

1
2
3
4
10
20
30


I tried the CInt() function but that did not work.

Any ideas?