Line plot displaying lines not defined by the data

[anja summer]

I am trying to present the labour force participation trends across EU countries from 1990 to 2022. I noticed there are linear lines not corresponding to the dataset present in the plot. The data set is balanced. I used the basic code -twoway line mLFP fLFP year, legend(label(1 "mLFP") label(2 "fLFP")). I can't seem to find an explanation for this.

[Clyde Schechter]

twoway line mLFP fLFP year, legend(label(1 "mLFP") label(2 "fLFP")) sort

[anja summer]

Thank you, Clyde, for your response, however adding sort at the end seems to not help. This is the graph I get.

[Maarten Buis]

This is a problem with your data, not with the graph: For each year you have multiple values of mLFP and fLFP. You need to decide which of these Stata should draw. That is something you need to fix first before graphing.

[Nick Cox]

I guess the issue here is that you have multiple countries. So, try some equivalent of

sort country year

and add the option

c(L L)

to your graph command.

[anja summer]

Thank you all for your replies! The issue is fixed with the use of Nick's code!