Histogram xlabels: Removing scientific notation, selecting values

[paulvonhippel]

I have data, attached, on sales of several hundred firms. Stata is giving me a histogram with evenly spaced horizontal categories that use scientific notation.
I would like to use non-scientific notation, with commas, and call out the two largest values as missing value codes. Below I illustrate what Stata gives me and what I want. I got what I want by editing the image in paint.net -- is there a way to get what I want directly from Stata?

histogram O9, freq

What Stata gives me:


What I want:

[paulvonhippel]

Sorry, I had a little trouble uploading the images. Let me try again.
What Stata gives me:

What I want:

[Andrew Musau]

There is no display format that places intermediate commas, so you will need to use value labels, e.g.,

xlab(0 "0" 2e+10 "20,000,000,000" ...)

Otherwise, without commas

xlab(, format(%13.0g))

[Nick Cox]

Perhaps the point of this is pedagogic, to show the (bad) effects of taking codes for missing literally, here meaning numerically.

Otherwise, I would use billions, or logarithms, or quite possibly both.

[paulvonhippel]

It's pedagogic, yes.