set value to 0 if series data doesn't have that key, as column charts can't have nulls