use full number format after updating the chart
this fixes the bug that text prepended or appended to numbers
disappears after updating the chart