I approximated your desired Axis scaling by taking the log of the data, and then applying the Value Labels column property to the data. I used the Allow Ranges
Then I just plotted the data
It isn't exactly what you want, but it might be useful. Others in the community may have a better solution
Jim