|Hi, basically my problem is with my values for the Y axis in a scatter graph.|
My scale at the moment is too big as my values go from 957 tonnes to 46 million tonnes. If I use a scale only in millions, then my values under a million all show up at zero in the graph. But if I use a scale of 10,000s then my Y axis is enormous.
Any ideas how I can overcome this problem? And is it even possible to this in Excel?