Fixing bar cart legend

[Tina Samuel]

Hello statalist community, I am trying to graph a bar chart for labor force participation by sex across different countries in different years.
This is the code I am using :
graph bar (mean) crlfsr1 if age >= 15 & age <= 64, over(sex) over(country_year) legend(on)
However the legend doesn't generate for the sex and the graph appears like this:

Any idea How I can fix the code so that the legend displays gender rather than mean of crlfsr1?
Thank you.

[Andrew Musau]

You probably want the option -asyvars-. See

help graph bar

graph bar (mean) crlfsr1 if age >= 15 & age <= 64, over(sex) over(country_year) asyvars legend(on)

[Tina Samuel]

Thank you sir, this worked perfectly. I have an issue with another graph, it's really simple but I am not sure why it's not working properly. I want to generate a line graph that represents the mean of crlsfr1 over ages and sex. I can do it as a bar chart, I attached as a reference but It's not working as line.

[Andrew Musau]

If you have multiple observations per time-period, you need to aggregate the data. collapse will create period means.

webuse grunfeld, clear
qui sum mvalue, d
gen smallcap=mvalue< r(p50)
collapse invest, by(smallcap year)
tw line invest year if smallcap, sort|| line invest year if !smallcap, sort||, leg(order(1 "Small-Cap" 2 "Large-Cap")) xtitle("")

[Nick Cox]

Trivia time. EGY-O6 should presumably be EGY-06, as code for Egypt in 2006.

[Tina Samuel]

Thank you all for the help.