Chart in Access
Chart in Access
(OP)
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
thx for help





RE: Chart in Access
Selection.NumberFormat = "0.00"
OR
Cells(row, column).NumberFormat = "0.00"