Data Tables in Chart, decimal points.

[GoinDeep]

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?

 

[pdx_man]

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

 

[GoinDeep]

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!

 

[pdx_man]

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