Chart in Access

[milz]

Do somebody know how i can change the decimals in the Chart.DataTable via vba? Because i have sale values and i need 2 decimals. The Chart is in a Form and the Data he get from a Table, every time when i open it i want to change that via vba. When i change it manually, close the form reopen it, the changes are lost.

thx for help

 

[TejuKey]

Select the cell (Cells(row, column).Select
Selection.NumberFormat = "0.00"

OR

Cells(row, column).NumberFormat = "0.00"