changing the color of just one bar in a single category bar chart

[Johnny Tad]

Im trying to generate a bar chart with one of the bars representing the average value across all IDs. And that bar should be the only differentiated color among the others.
So using syuse data, this is what i attempted with an error rejecting the "if" option

sysuse auto, clear
preserve
sort price
*add an observation for the average
expand 2 in L
replace price = . in L
egen avgprice =mean(price)
replace price = avgprice in L
replace make = "Average" in L
graph hbar price , over(make, sort(1) descending axis(off)) blabel(group, size(tiny)) bar(1 , bcolor(maroon))
*change the color of only the bar for "Average"
graph hbar price , over(make, sort(1) descending axis(off)) blabel(group, size(tiny)) bar(1 if make == "Average", bcolor(maroon))
restore
error: option if not allowed
How do I get a bar graph with one of the bars representing the average score of the values across the IDs and highlighting that with a different color? Also, I do not want the average bar to be included in the legend.
Thank you for your assistance.

[Andrew Musau]

https://www.statalist.org/forums/for...t-specific-bar

Use a loop to specify the colors of the individual bars if these are many (same color for all but the one you want to highlight).

[Nick Cox]

See also https://www.stata-journal.com/articl...article=gr0049

[Johnny Tad]

Thank you @Musau and @Nick. This was helpful.