I have a line graph chart based on a cross tab query in which the Data Table is displayed.

The problem is in the Data Table the values are displayed to 7 decimal points, I would like to limit the display to 4 decimal points like in the underlying cross tab query.

I can't seem to make this work, any ideas?

When in the design view of the graph, (within the design view of the form), double click on the values along the axis you wish to format. A box will pop up, Format Axis, with a tab for Number. Select Category Number, and set your desired decimal places.

HTH

pdx_Man,

The axis I can change the formating on like you mentined, but it is the Data Table below the chart I cant seem to format.

Thanks for the reply!

Have you tried to change the values on the control's Properties for Decimal Places or use a custom Format?