Bar graph with descending order of counts

[Inaamul Haq]

Hi all.
I have a simple bar graph to make in Stata. I want to make a frequency bar graph of rep78 using the auto dataset in which the bars are ordered in descending order of rep78 frequencies.

sysuse auto, clear
tab rep78, sort m

Here is what I want in Stata. This I made in Excel.

[Inaamul Haq]

I used this code and it works. But I think there must be a more efficient way to handle this type of bar.

sysuse auto, clear
contract rep78, freq(f)
gsort -f
graph bar (mean) f, over(rep78, sort(f) descending) ytitle(`"count"') caption(`"rep78"', position(6))

Kindly suggest.

[Andrew Musau]

sysuse auto, clear
gr bar (count), over(rep78, sort(1) descending  relabel(6 "Missing")) missing ytitle(count) caption(rep78, pos(6))

[Inaamul Haq]

Oh wow! That was simple. Thank you very much.