Hello everyone.

I am trying to create a bar chart which evaluates the labor market participation by nationality and needs to compare 2010 and 2016 with each other.

Using the following code I get a graph for which the percentage adds up to 100. So both 2010 and 2016.

Code:
 #delimit ;
seperate year, by(year)
graph bar (percent) labor_part [pweight=expan_indiv],     over(year, relabel(1 "2010" 2 "2016"))
                                                        over(nationality_cl) 
    bargap(10)
    asy
    title("Percentage of Labor Market Participation by Nationality and Year")
    ytitle("")
    note("Authors’ calculations based on JLMPS 2016")
    ymtick(10(5)25)
    legend(col(1) ring(0) position(2))
    graphregion(color(white))
    name(bar1, replace)
    blabel(bar);
#delimit cr
However I want to evaluate the distribution between 2010 and 2016 independently. So 2010 needs to add up to 100 and 2016 needs to add up to 100.

What do I need to change? I cannot attach the data since it is confidential.

Hope someone can help me!