Auto number format should allow for a uniform number format, e.g. when reading a chart it should be possible to decide if the number should be "shortened" to thousands/millions or a default "range".
This way the numbers will be coherent and uniform in a chart as a whole instead of having both thousands and millions in a chart: