Graph for panel data that combines and plots average

[Gabriel Temesgen]

Dears,
I want to generate linear plots for 18 countries' panel data in one graph.
I use the command xtline but it gives of every country plots separately. when I add overlay, it overlays all together. however, what I need is if I want to see the debt-GDP ratio of some SSA countries, can I see it in a single plot sothat I can say the average debt-GDP ratio of SSA countries is increasing/decreasing and so forth.
May you please drop me the syntax for that. Thanks
* xtline credit_gdp
* xtline credit_gdp, overlay

[Øyvind Snilsberg]

perhaps,

bys year: egen mean_credit_gdp = mean(credit_gdp)
bys year: replace mean_credit_gdp = . if _n>1
tw (line mean_credit_gdp year)

[Nick Cox]

Data like that make me think that the median or the geometric mean might work as well or better.

[Gabriel Temesgen]

It works. Thanks Oyvind Snilsberg