Chart Axis decimal places

[scotte16]

I am creating a database to store metal chemistry percentages and I have a report to show run charts of each element. Some of these percentages have 5 decimal places, but when I try to adjust the axis range in the property sheet, I will enter normal numbers (like 0.02 or 0.3) and the hash marks on the axis will be something like 0.3499999878. Normally, to fix this I would select "fixed" for the number type but then it shows up rounded with only 2 decimal places. Is there a way to specifically choose the amount?



Thanks.

[rpeare]

You have to edit the chart properties, not the data itself. Depend on what version/chart tool you're using it'll either be in the properties window, or if you double click on the chart in the report design view it'll let you format the various parts of the chart.

[June7]

You set axis scale range and number format properties of graph? If you want to provide db for analysis, follow instructions at bottom of my post.