applied data conversion for charts