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