Line graph includes undesired lines

[Harry Gommans]

Hi all,

I am trying to run a simple line graph of a panel dataset that has observations for countries in 20 years. The line graph should depict the average trend of these countries for two variables. Though it does, it also includes another line for both variables (which seems to be a straight line from the first-year value to the last-year value).

Here's my code:

tsset Country year
egen mean_gini_swiid = mean(gini_swiid), by(year)
egen mean_gini_mkt = mean(gini_mkt), by(year)
line mean_gini_swiid mean_gini_mkt year, legend(off)

This results in the following graph:

How can I get rid of this straight line?

[Nick Cox]

Try adding a sort option.

[Harry Gommans]

That works indeed, thanks so much Nick